How to fix an error "change password failed for login sa"?

Sometimes you receive following error while trying to reset MS SQL sa password via SQL Management Studio using Windows Authentication. Follow below steps to resolve it.

Error Message While Resetting SA Password

  1. Login to your Windows VPS via RDP (Remote Desktop Access). This tutorial will guide you to connect to Windows VPS server using the RDP from different operating systems.

  2.  Click on Start and go to SQL Server Configuration Manager.

    MS SQL Configuration Manager

  3.  Right click on the SQL Server and select Properties. In the Properties window, select Startup Parameters tab.

    Startup Parameters

  4.  In Specify a startup parameter field, type -m; (including semicolon), and click on Add button.

    Add Startup Parameter

  5.  Click on Apply button, and you will be asked to restart MS SQL service, Click OK to close the popup window and click on OK to close the properties tab.

    Restart MS SQL Service Pop-up

  6.  Right click on SQL server, and restart the MS SQL service.

    Restart MS SQL Service

  7.  Now, open Command Prompt and run the below query assuming your SQL Server instance name is SQLEXPRESS. Note that, we've reset the password to "AccuWebHosting" for this example, but you'll have to replace your choice of password in @new argument.

    osql -E -S .\SQLEXPRESS
    exec sp_password @new='AccuWebHosting', @loginame='sa'
    go
    alter login sa enable
    go
    exit


    MS SQL Query From Command Prompt

  8. Again go to SQL Server Configuration ManagerRight click on MS SQL server and select Properties. In the Properties window, select tab Startup Parameters. From the startup Parameter list, select -m; from the list and click on Remove button.

    Remove Startup Parameters

  9.  Click on Apply button, you will be asked to restart MS SQL service, Click OK to close the popup window and click on OK to close the properties tab.

    Restart MS SQL Service Pop-up

  10.  We need to restart the MS SQL service again. Follow step #6 to restart the MS SQL service. Now you can login to SQL Server Management Studio using the new password AccuWebHosting.

  • 0 Users Found This Useful

Was this answer helpful?

Related Articles

Comparison of MS SQL Server 2008 V/s. MS SQL Server 2012

Following is a feature comparison between MS SQL Server 2008 and MS SQL Server 2012. MS...

How to fix "Upgrade Error - Valid Database compatibility level and successful connection rule"?

One of our Windows VPS customers wanted to upgrade SQL Server from SQL Server 2008 R2 to SQL...

How to create a Database in MSSQL Server?

If you have a Windows VPS / Dedicated server with MSSQL Server and WebsitePanel installed, you...

How to Increase the MS SQL Remote Query Timeout?

MS SQL Server has an option called Remote Query Timeout to specify the time (in seconds), a...

How to take MSSQL database offline or bring it online?

Sometimes, you come across to a situations when you are required to physically move the database...