How to fix SQL Server error 18456? I am seeing a message “Login failed for user - Error 18456 - Severity 14, State 38”.
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.
State codes and their meaning. How to Fix SQL server error 18456? Here are the steps you can follow to fix SQL server error 18456:
Here are the steps you can follow to fix SQL server error 18456:
- Step 1: Log In with Remote Desktop
- Step 2: Run Microsoft SQL Server Management
- Step 3: Checking the Server Authentication Mode
- Step 4: Restart the SQL Service
- Step 5: Checking SQL User Permissions
- Step 6: Mapping the User to the Database