<

Know How to Reset SQL Server SA Password

Published on
219 Points
219 Views
Last Modified:
SysTools
SysTools Simplifying Technology Leading  in Data Recovery, Data Migration & Data Backup With 200+ Solutions.  https://www.systoolsgroup.com/
A discussion about resetting SQL Server SA Passwords

"I have recently lost SA password of my SQL Server database. Although, the database I am trying to connect contains crucial details of my company. Even I tried so many times to reset SA password in SQL but I was unable to get through. Please suggest me a suitable solution that helps to resolve this issue."


System Administrator (SA) has the administrative login for Microsoft SQL Server. At times, some users may forget the SQL Server SA password. Thus, in such cases, users try to reinstall the SQL Server or just drop everything and go. For some reason, if users are unable to recall a new password and Windows account tells that users do not have permissions to change it. 


Therefore, in the upcoming section, we will discuss several ways to reset SQL server SA password in an absolute way.


Steps to Reset SA Password From MS SQL Server


Go through the following set of instructions by which users can easily reset SQL SA password using SSMS. Let us have a look:


Step 1: First, go to the Start icon, select All Programs and then, Microsoft SQL Server 2005. Now, click on SQL Server Management Studio Express.

Step 2: After that, you need to connect to the local default instance of SQL Server using Windows Authentication.

Step 3: After connecting you can either select SSMS or T-SQL for changing the SA password. With the help of SSMS, go to the Security node, expand Logins and then, right- click on SA (security administrator) log in to change password properties.

Step 4: Next, you have to enter the specific password in front of Password and Confirm Password area and then, press OK button


Automated Solution to Reset SQL File Password

If the above-stated method gets failed, users can take help of a reliable third-party tool. The name of that application is SQL Password Recovery tool. It is designed to reset unknown as well as empty passwords from the SQL database file. 


It permits a user to reset multiple user passwords within Microsoft SQL Server. With this utility, users can reset the password of any type or length without any data loss. Moreover, there is a need to install SQL server on the local machine to retrieve the password easily. The working steps of the tool are discussed below:


  1. Download and install SysTools SQL password reset tool on your machine

  2. Select Browse option provided to "Select (master.mdf) file" and then, load the master.mdf file.

  3. Next, choose the SQL version for the selected MDF file. Make sure to select the correct version if you have selected the wrong version, then it may lead to inconsistent behavior.

  4. The software will scan selected MDF (Master Database file) file and shows the scan completion window, once you have completed the scan process. Press OK button

  5. The software will list all end users that were created in MS SQL Server. Password column contains two values like Unknown and Empty.

    • Unknown: For this, you have the password and database will be encrypted.
    • Empty: For this, you do not want a password for the username. In fact, you can simply log into the account without entering a password.

  6. Select the particular user whose password you wish to reset and click the Reset button

  7. The software will prompt you to back up these two files i.e., Master.mdf and master.ldf before continuing

  8. Click on Reset button to proceed

  9. Now, Place the master.mdf on SQL Server (Default location) then launch the SQL Server and connect to the database without being constantly interrupted by the password restriction.


Final Words

In the above discussion, we have discussed a complete solution to reset SQL server SA password using SSMS (SQL Server Management Studio). Along with this, we have suggested a reliable third-party tool, i.e. SysTools SQL Password Reset tool. It is one of the best solutions that will help to reset both user and administrator passwords within the SQL server. Also, we have explained the complete working steps of the tool in a proper manner.



0
Comment
Author:SysTools
  • 2
  • 2
4 Comments
 
LVL 71

Expert Comment

by:Éric Moreau
advertisement to paid products is accepted now?
0
 
 

Administrative Comment

by:Andrew Leniart
Hi Eric,

Please note the circled "V" underneath the author's profile.

This indicates a "Vendor established relationship" with Experts Exchange.

All vendor article submissions to Experts Exchange are easily identifiable by the white circled V under article author profiles so you can easily choose to either read or skip such articles.

I hope that's helpful.

Regards,

Andrew Leniart
Experts Exchange Senior Editor
Private Message Me
0
 
LVL 71

Expert Comment

by:Éric Moreau
It is really time that the team spends time identifying articles in a different way in the search filter result, and identity even more those coming from vendors!
0
 
 

Administrative Comment

by:Andrew Leniart
Hi Éric,

It is really time that the team spends time identifying articles in a different way in the search filter result, and identity even more those coming from vendors!

You are welcome to request such a function (or learn about existing filtering options) by using the following resources available to you at Experts Exchange.

Share your feedback or report a bug on Experts Exchange

Experts Exchange Support Portal

I hope you find that helpful.

Regards,

Andrew Leniart
EE Topic Advisor / Senior Editor
1

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Join & Write a Comment

This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month