Francisco Tapia
fhtapia at gmail.com
Tue Aug 2 12:28:26 CDT 2005
FYI, the system is Sql server 2000 SP4 on windows 2003. I modified the sql agent proxy to be an administrator and it works fine. I can log into another pc w/ the sqlagentproxy domain user account and get access to the files I need. but if I switch the sql agent proxy to this account I receive an "access denied" for the files I want to run. On 8/2/05, oj <ojngo at rac4sql.net> wrote: > > SP3 and above add a new flag. You want to set it accordingly for your > environment. > --restrict to admin only. 1=yes, 0=no > EXECUTE msdb..sp_set_sqlagent_properties @sysadmin_only = 0 > go > Though, the error is pointing to something else. Try allow non-admin > users execute permission. > use master > grant execute on xp_cmdshell to public > -- > -oj > > > > ------------------------------ > *From:* bounce-sql2k-8507114 at ls.sswug.org [mailto: > bounce-sql2k-8507114 at ls.sswug.org] *On Behalf Of *Francisco Tapia > *Sent:* Monday, August 01, 2005 7:25 PM > *To:* SQL Server 2k List > *Subject:* xp_sqlagent_proxy_account > > I seem to be having a bit of trouble. my sql server crashed on thursday > and we were able to migrate the data over to a new server, one thing that > didn't come over well (i haven't been able to reproduce) is the call to the > xp_cmdshell. I ran the xp_sqlagent_proxy_account sproc pointing to a valid > nt domain user, our companies sqlcmd user. however even after I've applied > this user and double checked that the option for only sysadmins can run > xp_cmdshell is off, i keep getting the following error for my non-sysadmin > users: > Server: Msg 229, Level 14, State 5, Procedure xp_cmdshell, Line 2 > EXECUTE permission denied on object 'xp_cmdshell', database 'master', > owner 'dbo'. > > I cannot do a "dir" or anything, which that part sounds fine, I only need > to be able to execute a particular command. Thanks for your help in advance. > -- > -Francisco > http://pcthis.blogspot.com |PC news with out the jargon! > http://sqlthis.blogspot.com | Tsql and More... > --- You are currently subscribed to sql2k as: ojngo at rac4sql.net To > unsubscribe send a blank email to leave-sql2k-9078501N at ls.sswug.org------------- See > http://www.sswug.org/archives for list archives. mailto: > listadmin at sswug.org with list issues. --- > You are currently subscribed to sql2k as: fhtapia at gmail.com > To unsubscribe send a blank email to leave-sql2k-9078501N at ls.sswug.org > ------------- > See http://www.sswug.org/archives for list archives. > mailto:listadmin at sswug.org with list issues. > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...