Proxy Account

From: John (John_at_discussions.microsoft.com)
Date: 01/19/05 

Date: Wed, 19 Jan 2005 12:43:02 -0800

I have been trying to use xp_cmdshell with little success.
I have setup a proxy account. The command creates a text file that is able
to be placed on the local hard drive of the server. However, it fails to
put it on a networked drive. The proxy account has access to the networked
drive.

The only thing that I can think of that is left is that the proxy account is
the same account as the sql server login. I don't know if this might be
causing the problem. Also, maybe the proxy account isn't a "true" proxy
account. Does anyone know how I can check to ensure this account is a true
proxy account? I am not a network admin and don't have anyone here whose
responsibility is to check these things. However, the account that I did
setup as the proxy account does have rights to the network location and the
command does run successfully if it outputed to the local hard drive.

Any ideas would be appreciated.

Thank you

Relevant Pages

  • RE: SQL Server Agent Proxy Account logon Failed
    ... This proxy account is part of the local Administrators group which has "Access this computer from the network" right enabled. ... The Job is still failing everyday. ...
    (microsoft.public.sqlserver.security)
  • Re: Proxy Account
    ... you might try logging in interactively as the proxy account ... Try running the BCP command ... I am not a network admin and don't have anyone here ...
    (microsoft.public.sqlserver.programming)
  • Re: Proxy Account
    ... >> The SQL account should have write access on the remote location you are ... The command creates a text file that is ... The proxy account has access to the ... I am not a network admin and don't have anyone here ...
    (microsoft.public.sqlserver.programming)
  • Re: Proxy Account
    ... The SQL account should have write access on the remote location you are ... The command creates a text file that is ... The proxy account has access to the ... I am not a network admin and don't have anyone here whose ...
    (microsoft.public.sqlserver.programming)
  • Re: Proxy Account
    ... >> I have setup a proxy account. ... The command creates a text file that is ... The proxy account has access to the ... I am not a network admin and don't have anyone here whose ...
    (microsoft.public.sqlserver.programming)
Loading