How to Unlock SQL Server Account

This updated guide examines How to Unlock SQL Server Account and organizes the essential facts, background, and practical takeaways in clear American English.

Method 1

Using the Command Prompt

PressWin+Rand typecmd. 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

Using SQL Management Studio

Log into your SQL Server by using Windows Authentication. In the Management Studio.
ExpandObject Explorerand open theSecurityfolder.
Now expand theLoginsfolder, right click on SA account and click onProperties.
Type a new SA password and confirm it. Then click on OK .

Method 3

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

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 � contextual image 11

FAQ

What is How to Unlock SQL Server Account about?

It provides a structured overview of sql, explains the main context, and highlights practical takeaways for readers.

Why does this topic matter?

Understanding the main concepts helps readers evaluate the issue, avoid common mistakes, and make better-informed decisions.

How should readers use this information?

Use the guidance as a practical starting point, confirm details that may have changed, and follow current product, safety, or security recommendations.