Message that SQL Server Log File Viewer shows:
Login failed for user [User]
Error: 18456, Severity: 14, State 38
What it actually means:
Failed to open the explicitly specified database
My Question:
Is there a list somewhere of all the variations of the 18456 errors (Login failed), for each combination of severity and state, with the helpful description text?
I've had a Google but can't find anything other than specific combinations.
Best Answer
State codes and their meaning.
More detailed information is available in Aaron Bertrand's blog.
To find the status code, you need to inspect the SQL Server Error Log after ensuring that failed logins are recorded in the error log.