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 http://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.