People often ask – How do I change the lost password of SQL Server SA account?
It is a very common glitch faced by users who uses SQL Server Management Studio; as they forget their complex password of User & System administrative account.
If you have ever needed to perform some changes in the database then, it becomes a cumbersome situation if you do not remember the password of your SQL account. No doubt, it becomes a struggle to find the password of the dedicated user name for the SQL database connection.
Moreover, it is not less than a nightmare, when you enter the Login credentials to access the SQL database and the error 18456 pops-up on the screen. It means login failed for user. It is a situation where user cannot access the database. To overcome this situation, you need to take help of some workaround that can fix this problem.
The good news is it’s easy to reset the forgot or lost password with SysTools SQL Password Changer Utility. No matter which account password you want to reset, the software easily change SQL Server Password for SA & User Login account.
This tool can unlock password of SQL Server 2017 / 2016 / 2014 / 2012 / 2008 / 2008 R2 / 2005 / 2000. And, it supports Microsoft Windows 10 Home or Professional, Windows 8.1 / 8 / 7.
Let’s check out how SQL Password Changer Remove the Password
The entire procedure is divided into four simple stages to make process facile for the users.
Stage 1: Stop all Microsoft SQL Server Services
To start the software, it is important to stop all the Microsoft SQL Server Services. For this, you need to execute the following steps:-
Step 1: Press the Windows Key along with R to open Run dialog box.
Step 2: In Run box, type ‘compmgmt.msc’ under the Open field and click on OK.
Step 3: A Computer Management window appears on the screen. Here, you need to click on Services and Applications section.
Step 4: After that, you need to choose SQL Server Services.
Step 5: Here, you will get all he SQL Server services along with its State. Just stop all the services.
Stage 2: Open SQL Password Changer & Browse MDF File
Once you have stopped all the services, start the Software. On the welcome screen, you will see a very simple and navigable interface. All the options are clear to you. You need to click on Browse option in order to provide the ‘master.mdf’ file. SQL Server Master.mdf file comprises all the login details, including SA and User login account.
Stage 3: Select the Login Name to Reset Password
Once the master.mdf file scanning gets completed, all the User Name appears on the software panel, including System Administrative & User along with Password Status either UNKNOWN or Not Set.
The Password Status UNKNOWN means – a password is applied to this User name. On the other hand, the password Status Not Set signifies – No password is applied to this Login Name.
Stage 4: Time to Reset SQL Password
Just check the box corresponding to User Name and click on Reset Password button. A Password Settings pop-up appear on the screen. Here, you need to input the new password and confirm the password by entering it again and click on OK.
Step 5: Voila! The password is reset
Hurray! The SQL Server password gets reset within a few clicks. Now, login to SQL Server Management Studio with this Login name and new password.
That’s all about how to reset SQL Server SA or User password with SQL Password Changer. So, whenever you faced a similar situation then, install this utility and forgot all your problem.
Do you want to learn Microsoft SQL Server DBA Tutorials for Beginners, then read the following articles.
1,904 views last month, 3 views today