Reset SA Password without Opening SQL Server Management Studio
As you have known, SQL Server SA password can be reset by login to SQL Server Management Studio Express with Windows Authentication. This video shows you how to reset SA password without login to SQL Server or SQL Server Management Studio.
Summary steps:
Step 1: Stop SQL Server services.
Step 2: Install Asunsoft SQL Password Geeker.
Step 3: Click Open File button.
Step 4: Browse for the master.mdf file and import it.
Step 5: Select the SA user and click on Reset button.
Step 6: Type a new password for the SA account.
It will prompt that SA password has been successfully changed.
Finally, close SQL Password Geeker and start SQL Server services. Then you can use the new SA password to login to SQL Server.
In addition to this video you also can refer to http://www.instructables.com/id/Reset-SQL-Server-Lost-SA-Password-without-Login/
Video Length: 02:40
Uploaded By: Ting Xiao
Published: 8/7/2014
View Count: 2,377