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: Click to share on Facebook (Opens in new window) Facebook Click to share on Tumblr (Opens in new window) Tumblr Click to share on LinkedIn (Opens in new window) LinkedIn Click to share on Reddit (Opens in new window) Reddit Click to print (Opens in new window) Print Click to share on X (Opens in new window) X Click to email a link to a friend (Opens in new window) Email Click to 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 ↓
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