How to Unlock SQL Server Account

Method 1 of 4:

Using the Command Prompt

Press Win+R and type cmd. Hit enter. The Command Prompt will be appeared.
Run Osql –S ComputerName –E command and hit enter.
Now run EXEC sp_password NULL, 'NewPassword', 'sa' and hit enter.
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.

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

Method 3 of 4:

Using SQL Script

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

Method 4 of 4:

Using Third Party Software

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

Jessica Tanner

Update 05 March 2020

You should read it

May be interested

CREATE LOGIN command in SQL Server
the article explains how to use the create login command with syntax and examples.
ALTER LOGIN command in SQL Server
the alter login command is used to modify the identity used to connect to sql server.
6 ways to unlock iPhone without password
it's annoying when your phone is locked and there's no way to get it back on. fortunately, there is still hope. if you want to unlock your iphone without a passcode, here are some methods you can try.
US police scramble to buy tools to unlock all iPhones despite the price of up to $ 30,000
grayshift has announced a product that can unlock all iphones despite being in ios 11 called graykey. soon, this tool attracted the attention of the american police force. many us federal agencies have purchased graykey.
How to unlock 90 FPS and 120FPS on Speed War
how to unlock 90 fps and 120fps on speed war. with the tips in this article, you can unlock a higher fps and experience this game in the best possible way.
Instructions for unlocking Windows computers with fingerprints on Android phones
how to unlock using the remote fingerprint unlock application will help you unlock your computer with your android phone
The difference between web server and app server
you have probably seen that the terms web server and app server are often used interchangeably as if they are related to the same thing and also facilitate the website to function properly. but in reality, they are not the same.
The former Apple engineer claims to be able to unlock all iPhones for $ 15,000
grayshift company of a former apple security engineer has announced a tool that can unlock ios 11 devices but still has some limitations.
Create a new local user account in Windows Server 2016
creating a new user account in windows server 2016 is not much different from previous versions of windows server, very quickly and simply. here is how to do it.
8 ways to secure SSH server connections on Linux
the server root account with open ssh access may be at risk. and especially if you are using a public ip address, it will be a lot easier to hack the root password.