Home / server / Questions / 292172
In Process
alimack
Asked: 2011-07-21 01:18:39 +0800 CST

Error SQL Server 2005 Using Proxy to run Agent Job ConnGetProxyPassword

  • 772

I'm using a proxy to run several SQL Server agent jobs.
Essentially the jobs copy data from Excel spreadsheets into a dbs via a network shared drive. The jobs have been failing for several weeks with the following error:

"Unable to start execution of step 1 (reason: Error authenticating proxy SERVERNAME\sharename, system error: ConnGetProxyPassword). The step failed."

when I run it under the proxy account, if I run it under the SQL Server Agent then I don't have permission errors.

I've recreated the proxy accounts but this has made no difference. The password for the proxy is correct.

Banging my head against this - any suggestions? It's not password length which I've seen suggested online.

sql-server sql-server-2005 proxy

1 Answers

  1. Change the SQL Server Agent account back!

    • 0