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) Share this: Share on Facebook (Opens in new window) Facebook Share on Tumblr (Opens in new window) Tumblr Share on LinkedIn (Opens in new window) LinkedIn Share on Reddit (Opens in new window) Reddit Print (Opens in new window) Print Share on X (Opens in new window) X Email a link to a friend (Opens in new window) Email Share on Pinterest (Opens in new window) Pinterest Like Loading... Related
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 ↓
aiDeeva.com 
Pingback: How to connect to a instance of sql server 2005 on vista - dBforums
hi I tought state 16 was valid login but the targeted database is not accessable or non existant