I wanted to run the xp_cmdshell command and the SQL user id that run this command is not a sys_admin, so as per the micrsoft site. I executed 'sp_xp_cmdshell_proxy_account' sp with a userid and password. I still get the error as below:
Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 1
EXECUTE permission denied on object 'xp_cmdshell', database 'mssqlsystemresource', schema 'sys'.
for the 'sp_xp_cmdshell_proxy_account' ps I have tried with a local account in the DB Sever, a network account still the xp_cmdshell is not working.