ARTICLE

Change SQL Server 2005 SA Password

Posted by Nipun Tomar Articles | How do I March 22, 2007
This Article shows how to change the password of any account in SQL Server.
Reader Level:

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

 

Login to add your contents and source code to this article
post comment
     

There is another method to change SQL Server password when we forgot it: 1.Click Start, point to Run and type cmd, press Enter key. 2.The command prompt will appear. Run the command: Osql –S john –E 3.Replace john with your actual computer name. Then type this command to change your forgotten SA password.EXEC sp_password NULL, ’123456’, ’sa’ 4.Replace 123456 with the password you want.Type Go to make the change take effect. Now you are able to log into the SA account with your new password! http://www.top-password.com/knowledge/change-sql-server-password.html

Posted by Bill Allaire Apr 23, 2012

Change SQL Server Password by Windows Authentication

If Builtin/Administrator is present in SQL Server, you can login with an ID which is member of Administrators group and change sa password in SQL Server. Just do as follows:
1. Login into SQL server using Windows Authentication.
2. In Object Explorer, open Security folder, open Logins folder. Right Click on sa account and go to Properties.
3. Type a new SQL sa password, and confirm it. Click OK to finish.
After restarting SQL Server and all its servers, you can log into SQL Server by sa login with new SQL sa password.

Posted by yee lau Aug 30, 2010
Posted by Nipun Tomar Sep 03, 2008

Hi i have a doubt abt in sql server 2005. But i forget my user name and password . so could you help is there any remedy to find out the user name and password.. could you resolve my problem

Posted by Elan Maha May 10, 2007
COMMENT USING
PREMIUM SPONSORS
Over-C is a holistic consortium of communications and technology specialists. We build, deploy and market both business as well as consumer products and solutions.
Get Career Advice from Experts
SPONSORED BY
  • PDF reports have never been easier to create. With our included WYSIWYG Designer, you can layout your reports, set up your data source and let DynamicPDF ReportWriter do the rest.
Join a Chapter