By Hally | Last Updated
When I prepare to access SQL Server using SQL Server Authentication Mode, I suddenly find the SA login password is incorrect. But now I want to edit tables in database file. How can I access SQL Server Database without password?
Actually, besides SQL Server Authentication Mode, there is Windows Authentication mode available for SQL Server connection. If you have Windows admin privileges for identity certification, please choose Windows Authentication on SQL Server logon screen, and click "Connect" to access SQL database file.
However, if Windows Authentication cannot work, or you would like to login into SQL Server with SA account in local computer, that would need SA password. So now let's see how iSunshare SQL Password Genius helps to access SQL database when users have no SA password.
Step 1: Download and install iSunshare SQL Password Genius on computer.
Suggest the full version one, because trial version only could show users for SQL database file, but not reset unknown SQL user password.
Step 2: Run SQL Password Genius and import SQL database master file.
Tips: Before you run SQL Password Genius, please stop SQL Server Services. If it starts, SQL unknown password would not be reset successfully.
Browse SQL Server master file in your computer by clicking Open File button on software screen. Open it and it would appear instantly in this SQL password recovery software. At the same time, all the users and password status for database file are listed in table under master file. MDF file location: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Step 3: Set a new password for SA account.
Select sa in user list and click Reset button. A dialog pops up, type a new password in box and click OK.
When you get "Password successfully changed" message, click OK to finish SA password reset.
Now, you have gotten a new SA password, so you can close SQL Password Genius, restart SQL Server Service, and then access SQL database file with new SA password.
Related Articles: