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 hits were a generic.
They 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 on 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 inaccessible.