Trouble with xp_cmdshell

Last Post 03 Mar 2003 02:24 PM by RSP_SQL. 4 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Will192
New Member
New Member

--
03 Mar 2003 01:13 PM
This works SQL 7, but doesn't work in SQL 2000.

I have a user that has access to the master database. I run the following command from a query window logged on as that user:

EXEC master..xp_cmdshell 'dir'

I get the following error :

Msg 50001, Level 1, State 50001
xpsql.cpp: Error 87 from GetProxyAccount on line 604

I have not seen this error before. The user has execute access on xp_cmdshell. (I know that this is a big security risk giving a user those rights)

Any thoughts? Thanks in advance for any help on this problem.

Will192

JaredK
New Member
New Member

--
03 Mar 2003 02:22 PM
Here's a link to a full explanation and fix.

http://databasejournal.com/features...hp/1580041
RSP_SQL
New Member
New Member

--
03 Mar 2003 02:24 PM
The default in SQL 2000 is to deny CommandExec to Non-Sa (non-sysadmins). Check to make sure the proxy account has the proper rights.
satya
New Member
New Member

--
04 Mar 2003 12:33 AM
Valid link by Jared, refer to books online about xp_sqlagent_proxy_account for more information.
Will192
New Member
New Member

--
04 Mar 2003 07:13 AM
Thanks guys. That fixed it.

Will192
You are not authorized to post a reply.

Acceptable Use Policy