HomeProgramSQL

How to Unlock SQL Server Account

Method 1 of 4:

Using the Command Prompt

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

Using SQL Management Studio

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

  1. How to Unlock SQL Server Account Picture 5
    Log into your SQL Server by using Windows Authentication. In the Management Studio.
  2. How to Unlock SQL Server Account Picture 6
    Expand Object Explorer and open the Security folder.
  3. How to Unlock SQL Server Account Picture 7
    Now expand the Logins folder, right click on SA account and click on Properties.
  4. How to Unlock SQL Server Account Picture 8
    Type a new SA password and confirm it. Then click on OK.
Method 3 of 4:

Using SQL Script

  1. How to Unlock SQL Server Account Picture 9
    Open SQL Server Management Studio to change the SQL Server password by using SQL Script.
  2. How to Unlock SQL Server Account Picture 10
    Open a New Query and write the query given in the image shown. Execute it.
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.
How to Unlock SQL Server Account Picture 11
5 ★ | 1 Vote
sqlusingservermethod

You should read it

SQL