I recently upgraded to SQL Server 2016. I was looking through the SQL Server logs and noticed the following error.
Login failed for user 'sa'. Reason: Password did not match that for the login provided. [CLIENT: ]
I have figured out that the running a transaction log backup triggers the error. The weird thing is that the maintenance job is successful. I can't figure out how the job can be successful with the failed login attempts. Another thing is that every time the job is ran, it logs exactly 30 failed attempts. What is failing to log in during the execution of the transaction log backup and how do you fix it?
Any ideas or solutions would be appreciated. Thanks