Home
Wifi Tips
Fix Computer
Windows 10
Windows 11
Artificial Intelligence
Space Science
Strange story
Table of Contents
Method 1 of 4:
Using the Command Prompt
-
Images 1 of How to Unlock SQL Server Account Press Win+R and type cmd. Hit enter. The Command Prompt will be appeared. -
Images 2 of How to Unlock SQL Server Account Run Osql –S ComputerName –E command and hit enter. -
Images 3 of How to Unlock SQL Server Account Now run EXEC sp_password NULL, 'NewPassword', 'sa' and hit enter. -
Images 4 of How to Unlock SQL Server Account 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.
-
Images 5 of How to Unlock SQL Server Account Log into your SQL Server by using Windows Authentication. In the Management Studio. -
Images 6 of How to Unlock SQL Server Account Expand Object Explorer and open the Security folder. -
Images 7 of How to Unlock SQL Server Account Now expand the Logins folder, right click on SA account and click on Properties. -
Images 8 of How to Unlock SQL Server Account Type a new SA password and confirm it. Then click on OK.
Method 3 of 4:
Using SQL Script
-
Images 9 of How to Unlock SQL Server Account Open SQL Server Management Studio to change the SQL Server password by using SQL Script. -
Images 10 of How to Unlock SQL Server Account 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.
5 ★ | 1 Vote
