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. On the above error number 8 for state indicates authentication failure due to password mismatch.

00:12:00.34 Logon Login failed for user ''.Īs defined above the Severity & State columns on the error are key to find the accurate reflection for the source of the problem. You might look into a corresponding entry in log as: 00:12:00.34 Logon Error: 18456, Severity: 14, State: 8. So to investigate further you need to look at relevant SQL Server instance error log too for more information on Severity & state of this error. By default the Operating System error will show 'State' as 1 regardless of nature of the issues in authenticating the login. Ok now what, by looking at the error message you feel like this is non-descriptive to understand the Level & state. Obviously if the necessary prvileges are not been set then you need to fix that issue by granting relevant privileges for that user login.Īlthought if that user has relevant grants on database & server if the Server encounters any credential issues for that login then it will prevent in granting the authentication back to SQL Server, the client will get the following error message: Msg 18456, Level 14, State 1, Server, Line 1 First task you might check is to see whether that user has relevant privileges on that SQL Server instance and relevant database too, thats good. By default login failed error message is nothing but a client user connection has been refused by the server due to mismatch of login credentials.

Sql error 18456 state 1