Login Failed For User sa error 18456
Tech Tips :: Databases :: MS SQL Server
Page 1 of 1
Admin- Admin
- Posts : 60
Join date : 2009-06-05 -
Re: Login Failed For User sa error 18456
Admin 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
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 : 60
Join date : 2009-06-05 -
Similar topics» Error: Failed to access IIS metabase problem
» HTTP Error 500.0 - Internal Server Error Calling LoadLibraryEx on ISAPI
» Load Report Failed
» XML Parsing Error: not well-formed
» SubReport Report Source error
» HTTP Error 500.0 - Internal Server Error Calling LoadLibraryEx on ISAPI
» Load Report Failed
» XML Parsing Error: not well-formed
» SubReport Report Source error
Tech Tips :: Databases :: MS SQL Server
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|