How to Change SA Password in SQL Server 2005

June 11th, 2012 by Admin Leave a reply »

Forgot SQL Server password and unable to login using the SA account? If you happen to forget your SQL Server password for sa account, then here’s a simple query to help you reset it:

GO
ALTER LOGIN sa WITH DEFAULT_DATABASE=master
GO
USE master
GO
ALTER LOGIN sa WITH PASSWORD=N'MyNewPassword' MUST_CHANGE
GO

In case you remember your old password and want to change the sa password, use this query:

ALTER LOGIN sa WITH PASSWORD = N'MyNewPassword' OLD_PASSWORD = 'MyOldPassword';
GO

You aslo can get a third-party tool to change SQL password. SQL Server Password Changer is one of the best MS SQL password reset tools which can help you change SQL Server password in a few seconds. It allows you to change SQL sa password on SQL Server and Express 2000/2005/2008.