Archive for the ‘SQL Server’ category

How to Change SA Password in SQL Server 2005

June 11th, 2012 by Admin

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.