Counter of Festivals

Ashok Blog for SQL Learners and Beginners and Experts

Friday, 14 February 2014

Login description of ERROR STATE & ERROR DESCRIPTION

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