If there is a mismatch in SA password the state will be 7 and for any other logins the state is 8. I have a windows account test (dl7728 est) but I am specifying it as a sql account and trying to login here and let’s see what the error log says This state occurs when a user try to login with a WINDOWS account but specifying that as a sql account. 10:57:30.520 Logon Login failed for user 'DOESNTEXIST'. I am logging in to my 2005 instance with a username called DOESNTEXIST and let’s see what the error state in error log is. This error mostly comes in when users specify wrong user name or misspell the user name.

This state occurs when a user logs in with the name that doesn’t exist on the sql server. But from sql 2005, each and every logon failure has certain describing entries for different states for all login failures.

The troubleshooting was quite tougher here. STATE 1: This state occurs for all user access problems in sql server 2000. In this article I will be taking you through the different states associated with this error along with reason and remedial action. And moreover this error 18456 is a generic message and the state described with this error in sp_readerrorlog is important as that can be handy to track down the exact reason. INTRODUCTION: This error is the most unanimous when it comes to sql server user rights. Troubleshooting Login failed Error 18456

Sql error 18456 state 1