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.
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.
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.
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.
- Azure sql password validation failed
- How to Install SQL Server Management Studio [SSMS]
- How To Enable Query Store In SQL Server
I am Bijay having more than 15 years of experience in the Software Industry. During this time, I have worked on MariaDB and used it in a lot of projects. Most of our readers are from the United States, Canada, United Kingdom, Australia, New Zealand, etc.
Want to learn MariaDB? Check out all the articles and tutorials that I wrote on MariaDB. Also, I am a Microsoft MVP.
