I have the XP_cmdshell issues for the past two days in SQL2005 SP2 environment. There is a domain account with sysadmin privilege. I have created a proxy account
and gave the execute privilege for xp_cmdshell.
If i try to run the following commmand
EXEC master..xp_cmdshell 'dir *.txt'
Msg 15121, Level 16, State 10, Procedure xp_cmdshell, Line 1
An error occurred during the execution of xp_cmdshell. A call to 'CreateProcessAsUser' failed with error code: '1314'.
But if i give sysadmin priv and then i try to execute. It worked. I cant give sysadmin priv so i m using a proxy account.
Whether any one have solution for it.
View Complete Post