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
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.