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_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.

LVL 5
ViggeeAsked:
Who is Participating?
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
xp_CmdShell Requires CONTROL SERVER permission even after it has been enabled through the Surface Area Config tool.
So you can either grant the login(s) in question CONTROL SERVER permissions:

GRANT CONTROL SERVER TO MyLogin;

or alter the permissions of the sys.xp_cmdshell proc:

USE master;
GRANT EXECUTE ON sys.xp_cmdshell TO MyUser;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.