Reader Level:
Article
How do I

Change SQL Server 2005 SA Password

By Nipun Tomar on Mar 22, 2007
This Article shows how to change the password of any account in SQL Server.

Changing the password in SQL Server was much easier. You just type the following thing and password for the account is changed:

     sp_password 'Old','New', Account

But this dont work for Sql Server 2005. Initially I thought whats worng with the SQL Server, but later I realized that it may be different for the two versions. At last I found it and here it is:

ALTER LOGIN Account_Name WITH
PASSWORD = 'New_Password'
OLD_PASSWORD = 'Old_Password';
GO