Blog Post

Troubleshooting Login Failed Errors on SQL Server 2008

,

While looking over my SQL Server Error logs, I noticed a small flurry of error messages like you see below, every two hours, at the top of the hour:

Login failed for user 'PRODUCTION\SomeSQLAccount'. Reason: Failed to open the explicitly specified database. [CLIENT: 192.168.xxx.xxx]

Error: 18456, Severity: 14, State: 38.

The fact that it happened at exactly the same time, every two hours, led me to believe that the error messages were being caused by a SQL Agent job. When I looked closer at my SQL Agent jobs, I quickly discovered the culprit, which was a job that was trying to access a database that was mirrored to another server. That was a DBA error that was easy to fix.

If you are actually having login failed errors, the resources below can help you figure out what is actually going on. 

Troubleshooting: Login Failed for User 'x'

SQL Server Authentication Troubleshooter

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating