SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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


No comments.

Leave a Comment

Please register or log in to leave a comment.