Unanswered: xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636
I want to give a non system administrator account permission to execute xp_cmdshell.
I'm testing it by running this:
xp_cmdshell 'dir c:\'
and getting this error
Msg 50001, Level 1, State 50001
xpsql.cpp: Error 1314 from CreateProcessAsUser on line 636
I have a setup a proxy account in SQL Server Agent as instructed - it's the same account that the SQL Server Service is running under.
I've deselected the 'only users with sysadm privilages...' option in SQL Server Agent properties and I've tried granting a variety of permissions to the proxy account based suggestions I've seen on google. It's a domain account which has local admin rights.
Other people seem to have found solutions but none of them have worked for me - any siggestions? SQL Server 2k Std Edn and Windows 2003 Server Std Edn.