How to: Change ’sa’ password on SQL server 2008

Tuesday, 15. December 2009

If you happen to forget your SQL Server password for ’sa’ account, then here’s a simple query to help you reset it:

ALTER LOGIN [sa] WITH DEFAULT_DATABASE=[master]

USE [master]

ALTER LOGIN [sa] WITH PASSWORD=N’MyNewPassword’ MUST_CHANGE

In Case you remember your Old Password and want to change ’sa’ password, use this query:

ALTER LOGIN [sa] WITH PASSWORD = N’MyNewPassword’ OLD_PASSWORD = ‘MyOldPassword’;

January 10th, 2010 at 11:53 am

spyware search Says:

Thanks so very much for publishing this.

Password Reset and Password Recovery Tools