1

I have some sql agent jobs that are using Windows NT Integrated Security to run (as specified in the Maintenance Plan's Manage Connections window)...eg. Translog backups.

While logged in as this account, I changed its password. Now the maintenance job is failing.

reason: Error authenticating proxy DOMAIN\Account, system error: The user name or password is incorrect

How do you fix this?

What I've tried:

  • Logging out of the server and back on
  • Per this article, Changed the connection to use SQL Authentication and then restarted SQL Agent...it still fails, but the error still is the same showing the same DOMAIN/Account that failed, so it is still using the Windows authentication instead of the new SQL login provided.
2

Figured it out.

The job step is also using a Proxy account, which is the same account. So you need to change the proxy account credentials as well.

2
  • You should accept this as the answer. Answering your own questions is encouraged. Sep 8 '20 at 19:51
  • 1
    @DavidBrowne-Microsoft I will, but can't until 2 days have passed per stackexchange rules.
    – crichavin
    Sep 8 '20 at 20:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.