In continuing with the theme of understanding error messages I'll discuss the "login failed" messages that are surfaced by the client and written to the server's error log (if the auditlevel is set to log failures on login which is the default) in the event of an error during the login process.
If the server encounters an error that prevents a login from succeeding, the client will display the following error mesage.
Msg 18456, Level 14,
State 1
, Server <server name>, Line 1
Login failed for user '<user name>'
Note that the message is kept fairly nondescript to prevent information disclosure to unauthenticated clients. In particular, the 'State' will always be shown to be '1' regardless of the nature of the problem. To determine the true reason for the failure, the administrator can look in the server's error log where a corresponding entry will be written. An example of an entry is:
2006-02-27 00:02:00.34 Logon Error: 18456, Severity: 14, State: 8 .
2006-02-27 00:02:00.34 Logon Login failed for user '<user name>'. [CLIENT: <ip address>]
ERROR STATE
|
ERROR DESCRIPTION
|
2 and 5
|
Invalid userid
|
6
|
Attempt to use a Windows login name with SQL Authentication
|
7
|
Login disabled and password mismatch
|
8
|
Password mismatch
|
9
|
Invalid password
|
11 and 12
|
Valid login but server access failure
|
13
|
SQL Server service paused
|
18
|
Change password required
|
Disclaimer: This posting is provided "AS IS" with no warranties, and confers no rights
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.