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