After changing the sa password of SQL server 2012, the automatic backup doesn't run any more.

Please see the log history:

Log history

The backup was not implemented by me.

Login failed for user 'sa'.
Reason: Password did not match that for the login provided.
[CLIENT: <local machine>]
09/18/2018 09:29:55,Logon,Unknown,Error: 18456 Severity: 14 State: 8.


Seems lite this is a Maintenance Plan. find the plan in SSMS, modify it, and change the connection attribute for this so you use the correct password or perhaps even use windows authentication instead of hard-wiring a password in the maint plan.

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.