Forgot or lost SQL Server “sa” password

Here’s a neat thing to remember if you’re using MSSQL:

To change the “sa” password, login to your computer using an administrator account. Open your SQL Server and log in using Windows Authentication. Open a new query window and type in the following command:

sp_password @new = 'new_password', @loginame = 'sa'

After that go to section Security –> Logins –> double click “sa” or choose properties. Go to “Status” and check to see if “Login:” is enabled. If not, enable it.

3 replies
  1. tom
    tom says:

    Forgot MS SQL Server Sa password? A few days ago, I set a sa password on the MS SQL Server database, but I did stupid thing and forgot the password. Fortunately, my friend told me to download MS SQL Server Password Unlocker from This program helps to reset sa password instantly. It is really fabulous.

    ~~~~~~~~~~~sorry! I have made a mistake on the first comment

Comments are closed.