Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

xp_cmdshell

Posted on 2006-11-08
3
5,646 Views
Last Modified: 2012-11-06
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.

0
Comment
Question by:Viggee
3 Comments
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 17903769
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

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how the fundamental information of how to create a table.

861 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question