Re: Execute permission on xp_cmdshell

From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 08/01/02 

From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS])
Date: Thu, 01 Aug 2002 19:57:31 GMT

Where is your text file? Does the proxy account have proper permissions to
access the text file?
If you login as the proxy account, can you run your BCP commands from
command line successfully?

Regards,

Lan Lewis-Bevan (MS SQL Support)

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

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: xp_cmdshell right for non sysadmin
    ... I did change the SQL agent proxy account info via Enterprise manger. ... For testing purpose, I login using this NT proxy account and try to execute xp_cmdshell, it works. ...
    (microsoft.public.sqlserver.server)