13:01:49.410 Logon Login failed for user 'aaa'. But the error shown in the SSMS window is 4064 but the error number recorded in error log is 18456. This state occurs for the logins in sql server when its default database is unavailable. To resume the service, use SQL Computer Manager or the Services application in Control Panel. 12:31:28.620 spid57 SQL Server service has been paused. But for this reason, there will also be other error number 17142. This state occurs when any login tries to get access to sql server with services paused on it. To overcome this error, you can add that domain login to sql logins explicitly provided you have create login permission. Even though it can access OS, it can’t login in to sql server. This state means the domain login trying to access sql server that wasn’t explicitly added to sql server. See more info on this error and visit _validate_output_arg.asp.
The policy API has rejected the password with error NERR_BadPassword. This state means that the password was rejected by the password policy check as an invalid one. 11:14:18.440 Logon Login failed for user 'docsadm'. 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\test) 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