Change SA Login Password Using SQL Query

In this post I will show you how to change SQL Server password using SQL Query.

This query is useful in scenarios where you might forget the password of SA login. In such scenarios this could become of much help instead of uninstalling the product itself.

Open SQL Server Management Studio. Open a new Query. Write the following script.

GO
ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]
GO
USE [master]
GO
ALTER LOGIN [sa] WITH PASSWORD=N'YourNewPassword' MUST_CHANGE
GO

Here replace ‘YourNewPassword’ with the actual password that you wish to mantain. Execute the script and the password gets changed without any trouble.