Error 18456, Severity 14: Login Failed States
Posted by Jugal Shah on April 24, 2009
| 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) |
How to connect to a instance of sql server 2005 on vista - dBforums said
[...] Number: 65536 Identified this error as following: Server is in Single-User Mode (2005) Source: Error 18456, Severity 14: Login Failed States Database Articles Probable Solution: Use "SQL Server 2005 Surface Area Configuration" to add yourself as [...]
Lars said
hi I tought state 16 was valid login but the targeted database is not accessable or non existant