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) |
Thursday, April 23, 2009
Error 18456, Severity 14: Login Failed States
Subscribe to:
Post Comments (Atom)
hi I tought state 16 was valid login but the targeted database is not accessable or non existant
ReplyDelete