Reader Level:
ARTICLE

Change SQL Server 2005 SA Password

On March 22, 2007 Articles | How do I
This Article shows how to change the password of any account in SQL Server.
  • 0
  • 0
  • 83419

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 9 years of experience in managing multi-disciplinary teams of varying sizes and complex programs of work. Has the ability to build stro...

  • 27rank
  • 4M readers
  • 1times
COMMENT USING

Trending up