Francisco Tapia
fhtapia at gmail.com
Mon Aug 1 22:32:41 CDT 2005
damn... that's the last time I go drinking and emailing ;-) well I checked the owner of both services as I suspected that first, they are both running on system admin accounts, and the agent proxy is set to a domain user. There seems to be some kind of mis-configuration that I missed when we installed this beast :S On 8/1/05, William Hindman <wdhindman at bellsouth.net> wrote: > > Francisco > > ...you might do better on the dba sql server list ...but for what its > worth, > take a look at who the owner is on your new server and what the group > policies are ...I would tend to suspect the problem is in the server os > configuration rather than the ss based upon what you described. > > William > > ----- Original Message ----- > From: "Francisco Tapia" <fhtapia at gmail.com> > To: <dba-ot at databaseadvisors.com>; "SQL Server 2k List" > <sql2k at ls.datareturn.com> > Sent: Monday, August 01, 2005 10:25 PM > Subject: [dba-OT] 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... > _______________________________________________ > dba-OT mailing list > dba-OT at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-ot > Website: http://www.databaseadvisors.com > > > _______________________________________________ > dba-OT mailing list > dba-OT at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-ot > Website: http://www.databaseadvisors.com > -- -Francisco http://pcthis.blogspot.com |PC news with out the jargon! http://sqlthis.blogspot.com | Tsql and More...