Forgot or lost SQL Server “sa” password

Share on facebook
Share on twitter
Share on linkedin
Share on reddit

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.

Armand Niculescu

Armand Niculescu

As the Senior Project manager, Armand is one of the rare kind of developers that can do both design and programming with equal skill. This, coupled with a solid background and many years of experience, enables him to see the big picture and plan for the small details.

4 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 https://www.passwordunlocker.com/sql-server-password-unlocker.com. 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.