How to Unlock SQL Server Account

Last Updated: October 21, 2021

Have you lost or forgotten your SQL Server login? Are you unable to access your SQL Server account? If you are an individual user in the SQL Server, you can contact your SA (system administrator) to reset a new password for you. But if you the SA and have lost the password, it could be a difficult situation for you. You need to change or reset the password to unlock the SQL Server. Some solutions are given below, through which you can change the SQL Server SA password.

Method 1

Method 1 of 4:
Using the Command Prompt

1
Press Win+R and type cmd. Hit enter. The Command Prompt will be appeared.
2
Run Osql –S ComputerName –E command and hit enter.
3
Now run EXEC sp_password NULL, 'NewPassword', 'sa' and hit enter.
4
Type Go to make it done. Now you can log into your SQL Server by using the new password.

Method 2

Method 2 of 4:
Using SQL Management Studio

The SQL Server password can be changed in Management Studio by using Windows Authentication.

1
Log into your SQL Server by using Windows Authentication. In the Management Studio.
2
Expand Object Explorer and open the Security folder.
3
Now expand the Logins folder, right click on SA account and click on Properties.
4
Type a new SA password and confirm it. Then click on OK.

Method 3

Method 3 of 4:
Using SQL Script

1
Open SQL Server Management Studio to change the SQL Server password by using SQL Script.
2
Open a New Query and write the query given in the image shown. Execute it.

Method 4

Method 4 of 4:
Using Third Party Software

1
Try a third-party tool to unlock the SQL Server accounts (system administrator as well as individual). Search online for reviews of suitable software.