HomeProgramSQL

How to Unlock SQL Server Account

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...
Method 1 of 4:

Using the Command Prompt

  1. How to Unlock SQL Server Account Picture 1How 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 2How to Unlock SQL Server Account Picture 2
    Run Osql –S ComputerName –E command and hit enter.
  3. How to Unlock SQL Server Account Picture 3How 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 4How 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 5How 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 6How to Unlock SQL Server Account Picture 6
    Expand Object Explorer and open the Security folder.
  3. How to Unlock SQL Server Account Picture 7How 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 8How 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 9How 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 10How 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 11How to Unlock SQL Server Account Picture 11
5 ★ | 1 Vote
sqlusingservermethod

You should read it

May be interested

SQL