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.

Picture of Armand Niculescu

Armand Niculescu

Senior Full-stack developer and graphic designer with over 25 years of experience, Armand took on many challenges, from coding to project management and marketing.

3 Responses

  1. 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.