Refer to common error states and their descriptions in following table, you would find the real reason for failed logining SQL Server. View the entry and just need to pay attention to the " State", which the server will accurately set to reflect the source of the problem. To determine the true reason for the SQL Server login failure, the administrator can look in server's error log where a corresponding entry will be written. We should know that the ' State' will always be shown to be ' 1' regardless of the nature of the problem. Msg 18456, Level 14, State 1, Server, Line 1 While you receive error 18456/18452 message, please check error state in SQL Server error log. Section 1: Check the Error State or Find Reason to This Error
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |