Problem
Recently I experienced a situation where a SQL Server login failed with this error message:
Error: 18456, Severity: 14, State: 10.
Login failed for user ‘SQL_Login’. Reason: Password validation failed with an infrastructure error. Check for previous errors. [CLIENT: XXX.XXX.XXX.XXX].
Can you help me decipher this SQL Server issue and correct it? Check out this tip to learn more.
| Error 18456, Severity 14: Login Failed States | |
| Login Failed states summary | |
| State | Description |
| 1 | Only state returned in SQL 2000. Server is in Single-User Mode (2005). |
| 2 and 5 | Invalid User Id |
| 6 | Attempt to use a windows login name with SQL Authentication |
| 7 | Login disabled and password mismatch |
| 8 | Password mismatch |
| 9 | Invalid Password |
| 10 | Read Ref Link #2 |
| 11 and 12 | Valid login but server access failure; Default Database access failure. Or Initial database connection failure in connection string. |
| 13 | SQL Server service paused |
| 16 | User doesn’t have permission to target database |
| 18 | Change password required |
| 23 | Server in process of shutting down, and user attempted to login. |
| 27 | Initial database could not be determined for session |
| 38 | Initial database could not be determined for session (SQL 2008) |
| 40 | Default database could not be accessed (SQL 2008) |
