"I unable to connect to my SQL Server 2012 by Windows Authentication and forgot SA password. How can I connect to my database? Please help!"
It seems a little tricky in this case. Fortunately, you can quickly recover SQL Server 2012 forgotten SA password with iSumsoft SQL Password Refixer.
iSumsoft SQL Password Refixer is a tiny but powerful program which specializes in resetting SA password and other users’ passwords on SQL Server 2014/2012/2008/2005. So you can use it to immediately recover access to SA account after you forgot its password and unable to connect to SQL Server 2012.
Step 1: Download and installation.
Open your browser to search “iSumsoft SQL Password Refixer” and go to iSumsoft official site. Then download and install SQL Password Refixer on your computer with SQL Server 2012 installed. You won’t need to make any extra settings to your system while downloading or installing.
Step 2: Stop SQL Server 2012 service.
SQL Server accounts passwords are stored in master database file (master.mdf). And this "SQL Password Refixer" just recovers password through accessing to the master.mdf file. Thus you need to firstly stop SQL server service so that the master.mdf file won’t be occupied.
Step 3: Add SQL Server 2012 database file.
Launch SQL Password Refixer. Click Open File and then navigate to the path to the master.mdf file. Select the file and add it to this program.
Tips: When it’s your first time to use this program to open your SQL Server master.mdf file, it won’t automatically navigate to the path to the master.mdf file. So you need to manually navigate to the path. Commonly the master.mdf file is located in the path: C:/Program Files(x86)/Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\master.mdf
Step 4: Recover forgotten SA password.
1. Once the master.mdf file is added into this program. It displays a list listing all User names and their indexes on your SQL Server 2012, and the SA account is in the first line. And you can see the forgotten SA password is labeled “Unknown”. Click to highlight the SA account and then click "Reset" button below.
2. Type a new password for the SA account in the Reset Password dialog and click OK to confirm.
3. Then a small dialog saying "Password successfully changed" pops up, click OK to close the dialog. Then in the list, you can see your SA password turn into your newly set password from “Unknown”. Thus you successfully recover forgotten SA password on your SQL Server 2012 through changing the forgotten password to a new one.
After that, restart your SQL Server service and then use the new SA password to connect to SQL Server 2012.
Tips: It’s thought the quickest and easiest way to recover forgotten SA password on SQL Server 2012 and other versions of Microsoft SQL Server.