Sunday, October 2, 2011

SQL Server Error 18456 Login Failed For User

In SQL Server's most common issue in securities is login failed for user, Error 18456.

To resolve 18456 error, you have to change the Server Authentication mode "SQL Server and Windows Authentication mode".

In order to resolve the above issue through selecting "SQL Server and Windows Authentication mode", please refer to the following steps:

Here is the error #18456 getting while connecting to the server through "SA" login and password.


Workaround: 
Step 1. Login to the Microsoft SQL Server Management Studio with Windows Authentication.



Step 2. In SQL Server Management Studio Object Explorer, right-click on the server, and then click Properties.



Step 3. Under the Server Properties, select "Security" page.

Step 4. Select the Server authentication as "SQL Server and Windows Authentication mode" and click Ok.




Step 5. After changing the server authentication mode from windows to SQL Server and Windows Authentication Mode, server needs to restart then only changes will effect.


Understanding "login failed" (Error 18456) error messages in SQL Server, "Error 18456" error message when you specify configuration, Login failed for user, microsoft sql server, error 18456 login failed for user in sql server 2012, error 18456 login failed for user in sql server 2008 R2, error 18456 login failed for user in sql server 2005, error 18456 sql server 2008, error 18456 windows authentication, error 18456 sql 2008, error 18456 state 38, error 18456 state 1, error 18456 state 16, error 18456 state 11, error 18456 severity 14 state 1

2 comments:

Post a Comment