![]() ![]() 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 ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |