0

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.

Improve this question
1
  • I suspect now, after two solid days of investigation that our dba changed the account that the SQL Server Agent runs under and as a result, the account can no longer use the proxy account I've set up.
    – alimack
    Jul 26, 2011 at 8:11

1 Answer 1

Reset to default
0

Change the SQL Server Agent account back!

Improve this answer
1
  • If this resolved the issue, please be sure to mark your answer as "accepted" when you are able.
    – jscott
    Jul 16, 2012 at 15:01

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .