Microsoft – SQLServer – Error Message – Login Failed Error: 18456, Severity: 14 State: 38

Microsoft – SQLServer – Error Message – Login Failed Error: 18456, Severity: 14 State: 38
Client Software logged a couple of SQL Server related error messages this morning.

The error message stated “Login Failed Error: 18456, Severity: 14 State: 38”.

Googled a bit for it, but most of the Blog entries were a bit generic.

The Blogs basically pointed to Database Accessibility permission issues.

There were helpful entries that suggested that we should initiate MS SQL Server Profiler

and track for “Security – Audit Login Failed”.

Did so, but nothing useful came up.

Sometimes it is hard to work for a Living.

Later it all made sense, the MS SQL Server was recently restarted and the failures were

due to the fact that the necessary “Database” Recovery that follows each SQL Server

Restart.

 

Was able to arrive at this from reviewing SQL Server’s Error Logs.

Obviously, it will be helpful if MS logged the Database that was inaccesible.

 

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s