How To Reset SA Password In SQL Server

by

Resetting the SA (System Administrator) password in SQL Server is crucial from a security perspective. In this article, I will walk you through all the approaches to reset sa password in SQL Server 2019.

How To Reset SA Password In SQL Server

Let us discuss all the approaches individually.

Approach-1 Using SQL Server Management Studio (SSMS)

To reset sa password in SQL server, follow the below steps.

1. Open SQL Server Management Studio (SSMS) and connect to SQL server instance.

2. Expand the Security folder, then expand the Logins folder, and then Right click on the SA account and select the Properties option as shown in the screenshot below.

How To Reset SA Password In SQL Server

3. Click on the General tab, Enter a new password in the Password field, enter the same password for the Confirm password field, and then click on the OK button as shown in the screenshot below.

how to reset sa password in sql server

Approach-2: Using ALTER statement

We can also execute the below Alter query to change the SA account password.

ALTER LOGIN sa WITH PASSWORD = 'Rajkishore@12345';

After executing the above query, It executed successfully, and the password also changed successfully, as shown below.

how to reset sql server sa password without login

Video Tutorial

Conclusion

Resetting the SA account password is so easy, as discussed in this article. You can either use the SQL Server Management Studio (SSMS) design approach, or you can also use the alter statement for this purpose. You can choose the right approach that suits your requirements.

You may also like following the articles below.