Reader Level:
Article

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

 

Nipun Tomar

Nipun is competent and experienced project leader, with 10 years of experience in managing multi-disciplinary teams of varying sizes and complex programs of work. Has the ability to build strong relationships wi... Read more

COMMENT USING