Viggee
asked on
xp_cmdshell
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_acco unt' 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_acco unt' ps I have tried with a local account in the DB Sever, a network account still the xp_cmdshell is not working.
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_acco
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.