I'm trying to execute xp_cmdshell in SQL-2008 by sql user ‘Checker’.
I’ve set sp_configure ‘xp_cmdshell’ to 1 and granted execute xp_cmdshell permissions to this user, but still getting error: The xp_cmdshell proxy account information cannot be retrieved or is invalid. Verify that the '##xp_cmdshell_proxy_account##' credential exists and contains valid information.
Online I found that I have to create a proxy credential like:
EXEC sp_xp_cmdshell_proxy_account ‘domain\checker, 'password'
The problem is that the last command is for OS user account only, and not for SQL login.
Is there a way to grant permissions to execute xp_cmdshell to SQL login?