Thursday, April 23, 2009

Error 18456, Severity 14: Login Failed States









































































Error 18456, Severity 14: Login Failed States 
Login Failed states summary
StateDescription
1Only state returned in SQL 2000. Server is in Single-User Mode (2005).
2 and 5Invalid User Id
6Attempt to use a windows login name with SQL Authentication
7Login disabled and password mismatch
8Password mismatch
9Invalid Password
10Read Ref Link #2
11 and 12Valid login but server access failure; Default Database access failure. Or Initial database connection failure in connection string.
13SQL Server service paused
16User doesn't have permission to target database
18Change password required
23Server in process of shutting down, and user attempted to login.
27Initial database could not be determined for session
38Initial database could not be determined for session (SQL 2008)
40Default database could not be accessed (SQL 2008)

1 comment:

  1. hi I tought state 16 was valid login but the targeted database is not accessable or non existant

    ReplyDelete