Login Failed For User sa error 18456

View previous topic View next topic Go down

Login Failed For User sa error 18456

Post  Admin on Mon Jun 17, 2013 7:45 am

Login Failed for user sa

Admin
Admin

Posts : 50
Join date : 2009-06-05

View user profile http://softro.forumotion.net

Back to top Go down

Re: Login Failed For User sa error 18456

Post  Admin on Mon Jun 17, 2013 7:46 am

In order to resolve the issue, please refer to the following steps:

1. Login to the MSSQL Server Management Studio with Windows Authentication.
2. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
3. Under the Server Properties, select a page of "Security".
4. Select the Server authentication as "SQL Server and Windows Authentication mode" and click Ok.


Ref: http://bodasher.xanga.com/767880134/login-failed-for-user-sa-microsoft-sql-server-error-18456/
------
Look at the state for the error 18456 from the error log. The state 1 always comes in SSMS or other tools , but the error logs will have the correct state number for this login failed error.
See this article http://sql-articles.com/articles/troubleshooting/troubleshooting-login-failed-error-18456 for all the states and use the doc to track down the reason for your login failure. 
If you get state 7 or 8 , then the password is not correct.



You can see this from SSMS --> new query and execute sp_readerrorlog
Alternatively you can open file from here - C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log\errorlog


exec sp_readerrorlog

Admin
Admin

Posts : 50
Join date : 2009-06-05

View user profile http://softro.forumotion.net

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum