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:]

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

This entry was posted in SQL Server 2008. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s