Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by
  • When: 18 Jul 2012 6:03 PM
  • Last revision by (Microsoft)
  • When: 12 Nov 2013 10:17 PM
  • Revisions: 7
  • Comments: 7
Options
RSSSubscribe to Article (RSS)
Engage!
Wiki Ninjas Blog (Announcements)

Wiki Ninjas on Twitter

TechNet Wiki Discussion Forum


Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  3 Methods to Change SQL Server Password

3 Methods to Change SQL Server Password

3 Methods to Change SQL Server Password

Table of Contents



Most security experts refer to enhancing SQL Server password security by changing password. To change SQL password is easy and one can make it through the following methods:

change sql server password

 

Method 1: Changing SQL Server user password by using MSSQL Server Management Studio Express


  1. Login to your Server using MSSQL Server Management Studio Express. Make sure to specify the correct SQL server for your database. 
  2. Expand the tree menu on the right by clicking on the "+" next to Security followed by clicking on the "+" next to Logins. Your users for the database in question should be listed.
  3. Right click on the user you wish to change the password for and choose the Properties option at the very bottom of the menu.
  4. Under the general section of the window you will see the option to type in and confirm a new password. Once the new password has been typed in, then click the "Ok" button in the lower right to finish.

 

Method 2: Altering SQL password by using sp_password


Any user can change his or her SQL user password with sp_password. However, only a System Security Officer who belongs to the Server’s security administrator group can execute sp_password to change another user’s password. Now please first log into SQL Server with Windows authentication mode, then open a new query window and next type the below commands to run sp_password to change password by pressing F5:
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]

 

 

Method 3: Change forgotten SQL Server password with SQL Password Recovery


It’s easy to change SQL password when you have access to the database. However, what if you lose access to the Server due to SQL Server password is forgotten or lost, how would you change your SQL Server password as easy as method 1 and 2? And is there any chance? Well, a professional SQL password recovery tool can tell you everything. Now please follow me to recover the forgotten SQL password with SQL Password Recovery:
Get SQL Password Recovery here.
Step1: After download the tool, then quickly install and launch it on a computer. Next in the pop-up interface of the tool, click “Open” to load target master *.mdf file.
Step2: After open the *.mdf file, all user names with their passwords will be displayed in a list.  Now just select the user account whose password needs to be changed and then click “Change Password”.
Step3: Now enter a new password for this account and then confirm it with clicking “OK” button to change SQL Server password process.

 

Source: http://www.sqlpassword-recovery.com/change-sql-server-password.html

, , , , ,
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 19 Jul 2012 10:41 AM

    Nice Tool Woniety....

    I like to add one more method os changing password in "forgotten SQL Server password ".

    Its a article given over : technet.microsoft.com/.../dd207004(v=sql.105).aspx

    This topic describes how you can regain access to the SQL Server Database Engine as a system administrator. A system administrator can lose access to an instance of SQL Server because of one of the following reasons:

    • All logins that are members of the sysadmin fixed server role have been removed by mistake.

    • All Windows Groups that are members of the sysadmin fixed server role have been removed by mistake.

    • The logins that are members of the sysadmin fixed server role are for individuals who have left the company or who are not available.

    • The sa account is disabled or no one knows the password.

    One way in which you can regain access is to reinstall SQL Server and attach all the databases to the new instance. This solution is time-consuming; and, to recover the logins, it might require restoring the master database from a backup. If the backup of the master database is older, it might not have all the information. If the backup of the master database is more recent, it might have the same logins as the previous instance; therefore, administrators will still be locked out.

    Start the instance of SQL Server in single-user mode by using either the -m or -f options. Any member of the computer's local Administrators group can then connect to the instance of SQL Server as a member of the sysadmin fixed server role.

    When you start an instance of SQL Server in single-user mode, first stop the SQL Server Agent service. Otherwise, SQL Server Agent might connect first and prevent you from connecting as a second user.

    When you use the -m option with sqlcmd or SQL Server Management Studio, you can limit the connections to a specified client application. For example, -m"sqlcmd" limits connections to a single connection and that connection must identify itself as the sqlcmd client program. Use this option when you are starting SQL Server in single-user mode and an unknown client application is taking the only available connection. To connect through the Query Editor in Management Studio, use -m"Microsoft SQL Server Management Studio - Query".

  • 31 Jul 2013 4:52 AM

    Nice article Woniety... can we recover "forgotten" password of windows logins using SQL Password Recovery tool?

  • 31 Jul 2013 4:56 AM

    Nice article Woniety... can we recover / change password of windows logins using SQL Password Recovery tool?

  • 31 Jul 2013 5:00 AM

    Nice article Woniety...

    can we recover "forgotten" password of windows logins using SQL Password Recovery tool?

  • 16 Nov 2013 7:29 AM

    Very good. Simple, quick and secure.

Page 1 of 1 (5 items)