Stage 1: Stop all Microsoft SQL Server Services
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.
Kaynak : bit.ly/2oQNutg