How to Fix Microsoft SQL Server SA Login Failed Error 18456? | Cannot log in using SA with SQL Authentication

Sunni Kumar

Fixed: Microsoft SQL Server Login Failed Error 18456 for User SA


How to Fix Microsoft SQL Server SA Login Failed Error 18456?

There may be two reasons why Microsoft SQL Server SA login is failed for Error 18456. On one hand, disable the SQL server authentication may let the user SA login failed for error 18456. On the other hand, the incorrect SA password may cause login failure too. So the solutions to the issue that Microsoft SQL server user SA login failed for error 18456 are to reset new passwords for the login accounts and enable the SQL server authentication mode.    

Step-1: Login with Windows Authentication

Using Windows local authentication to connect to the SQL server does not require password authentication, which can avoid login failed error 18456 for user SA.

1. Run the Microsoft SQL Server Management Studio.

2. Select the Windows Authentication from the draw-down list. 



3. Then click the "Connect" button to log in to the SQL Server.

4. Then expand the folder of Security from the Object Explorer. Then head to the folder of Logins.  


5. Double click at use sa. And then reset the password in sa Properties.


 

Step 2: Enable SQL Server Authentication Mode to Get Rid of Login Failed Error 18456

To get rid of the SA login failure error 18456, we are trying to enable the SQL server authentication mode.

1. Launch the Microsoft SQL Server Management Studio on you PC. Connect the SQL Server with Windows Authentication.

2. Then right click at the SQL server instance. Then click Properties.


3. In the Server Properties, click Security tab, and then select the second option "SQL Server and Windows Authentication mode". Click OK to finish. This mode allows users to login with the SA account and won't cause the login failed error 18456. 


4. Restart the SQL Server. You can go to Windows Service to restart it (or go to the SQL server configuration Manager to restart the SQL Server). 
   


Tags
Reactions

Post a Comment

1 Comments

  1. tomJuly 15, 2022 at 11:59 AM

    I know an organization who have private investigators for hire who can help you get into your spouse’s phones,emails remotely from your phone they can also help you with your
    * credit score
    * clearing of criminal record
    *increasing of school grades and any thing that has to do with hacking etc
    You can confirm for yourself from their email ethicalhackers009@gmail.com so you can also give your testimony
    Whatsapp No: +14106350697

    ReplyDelete