Error 18456, Severity 14: Login Failed States

2 Replies

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)

2 thoughts on “Error 18456, Severity 14: Login Failed States”

Pingback: How to connect to a instance of sql server 2005 on vista - dBforums
Lars November 30, 2010 at 12:44 pm

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

Reply ↓