Hi,
RE: SQL Server 2005
Is anyone familiar with this error message?
A non-sysadmin user received this error. Running sp_xp_cmdshell_proxy_account solved the problem.
Does this mean that ALL non-sysadmin users must have proxy accounts in order to use xp_cmdshell? Or is there something missing here?
Thanks
RE: SQL Server 2005
Is anyone familiar with this error message?
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.
Msg 15153, Level 16, State 1, Procedure xp_cmdshell, Line 1
A non-sysadmin user received this error. Running sp_xp_cmdshell_proxy_account solved the problem.
Does this mean that ALL non-sysadmin users must have proxy accounts in order to use xp_cmdshell? Or is there something missing here?
Thanks