Re: xp_cmdshell right for non sysadmin

From: mikew (anonymous_at_discussions.microsoft.com)
Date: 04/06/04 

Date: Tue, 6 Apr 2004 12:46:03 -0700

Hi, Sue. Thank you.
I did change the SQL agent proxy account info via Enterprise manger.
Why it is still not correct?
For testing purpose, I login using this NT proxy account and try to execute xp_cmdshell, it works.
But when I login in as a no-sa SQL user, it give me that error.
Thanks again. mike

Relevant Pages

  • Re: Granting xp_cmdshell permission to SQL Login
    ... Windows login, but I have a SQL Login. ... The 1329 error isn't related to the SQL login executing xp_cmdshell but is rather the Windows error code returned because the xp_cmdshell proxy account doesn't have the needed Windows permissions ... My guess is that the Windows login you mentioned is a sysadmin role member. ...
    (microsoft.public.sqlserver.security)
  • Re: cannot deliver sp_repldropcolum schema change
    ... makes sense to me that if this login is not part of the sysadmin server role ... then the proxy account is required, which isn't configured on your system. ... working when you use a sysadmin - now use the original login, ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server Agent
    ... the job will run as the job owner. ... The SQL Agent proxy account only affects resources outside of SQL Server. ... exists and the job is not running as sysadmin. ...
    (microsoft.public.sqlserver.security)
  • Re: Execute permission on xp_cmdshell
    ... Does the proxy account have proper permissions to ... If you login as the proxy account, can you run your BCP commands from ...
    (microsoft.public.sqlserver.security)