Login description of ERROR STATE & ERROR DESCRIPTION:
2007-05-17 00:12:00.34 Logon Error: 18456, Severity: 14, State: 8.
or
2007-05-17 00:12:00.34 Logon Login failed for user ''.
As defined above the Severity & State columns on the error are
key to find the accurate reflection for the source of the problem. On
the above error number 8 for state indicates authentication failure due
to password mismatch. Books online refers: By default, user-defined
messages of severity lower than 19 are not sent to the Microsoft Windows
application log when they occur. User-defined messages of severity
lower than 19 therefore do not trigger SQL Server Agent alerts.
Sung Lee, Program Manager in SQL Server Protocols (Dev.team) has
outlined further information on Error state description:The common error
states and their descriptions are provided in the following table:
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
No comments:
Post a Comment