AnswerBun.com

How to fix SQL Agent Job using Windows Security after password change

Database Administrators Asked by Chad Richardson on December 7, 2020

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 DOMAINAccount, 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.

One Answer

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.

Answered by Chad Richardson on December 7, 2020

Add your own answers!

Related Questions

Users on same server connect to MySQL with different hosts

1  Asked on December 12, 2021 by crm-dev

   

MSSQL TempDb full

2  Asked on December 8, 2021

     

MySQL: order tables by entity relations?

0  Asked on December 8, 2021

 

Schema level encryption in Postgres

0  Asked on December 8, 2021 by turgs

     

How to use GROUP BY on a CLOB Column

1  Asked on December 8, 2021 by dallincha

     

Ask a Question

Get help from others!

© 2022 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, MenuIva, UKBizDB, Menu Kuliner, Sharing RPP, SolveDir