Msg 15137, Level 16, State 1, Procedure sp_xp_cmdshell_proxy_account, Line 1
An error occurred during the execution of sp_xp_cmdshell_proxy_account. Possible reasons: the provided account was invalid or the '##xp_cmdshell_proxy_account##' credential could not be created. Error code: '5'.
I can execute this fine, but I think SQL Server does not validate the account on creation:
CREATE CREDENTIAL ##xp_cmdshell_proxy_account## WITH IDENTITY = 'Domain\Loggy', SECRET = 'PassyWordles'
If I attempt to execute xp_cmdshell with the above I get the message:
Msg 15121, Level 16, State 200, Procedure xp_cmdshell, Line 1
An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1385'.
OS Error 1385 means: "Logon failure: the user has not been granted the requested logon type at this computer."
This is not a problem with the account: copied and pasted the above works fine on a number of other servers. I suspect it is to do with the OS, but I am not certain. All security is managed by group policy.
SQL Server 2008 R1 on Windows 2008 R2
SQL Server 2008 R1 on Windows 2003
SSQL Server 2005 on Windows 2003