How to: Change 'sa' password on SQL server 2008
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]
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
Reference:
http://blog.passwordunlocker.com/how-to-change-sa-password-or-other-ms-sql-server-passwords/...
