April 25, 2005 at 6:09 am
I have faced a problem with one of my user site where xp_cmdshell has not worked. SQL 2000 with SP3a on Win2003 Server. Win2003 is configured as a Workgroup and not as a Domain.
When I login as Adminstrator (Windows Login) and login as a normal user in SQL who do not have Administrative privilages, when xp_cmdshell is executed gives Proxy error.
Have tried the settings in Job system tab and made Allow Non System Administrators also through the sp_command (now the checkbox is unchecked) but still it does not execute the xp_cmdshell. However if I login as sa it works.
When I tried through Enterprise Manager to remove the checkbox it asked for the User Name and the Domain name where as the Server is not configured as Domain. Have tried with Local Account also has not worked.
Is there anysolution available with Workgroup.
April 25, 2005 at 8:20 am
I have workgroups at home and I've used them on sql servers sat in a dmz. I always had the users/logins as administrators so cmdshell worked. You should be able to allocate permissions. For it to work across multiple servers you need to make the administrator pwd the same on each server. Whether this is good for a prod environment I don't know. < grin >
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
April 26, 2005 at 6:37 am
is there any document or any url link available which can be refered to sort this problem.
April 26, 2005 at 8:09 am
1. configure a SQL Server Agent proxy account to enable non-system administrators to execute the xp_cmdshell configure a SQL Server Agent proxy account to enable non-system administrators to execute the xp_cmdshell. Follow by Microsoft Article# 890775
2. Grand permission to execute xp_cmdshell to the group/account that you want to use.
Jie Ma
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply