<< Click to Display Table of Contents >> Navigation:  Password Recovery Programs > Advanced SQL Password Recovery > Program information > Working with ASQLPR

Microsoft SQL Server Engine uses strong encryption, and passwords cannot be recovered instantly. However, they can be changed or removed. Press Open file...and browse for the master.mdf file. ASQLPR shows the list of users; highlight the user you want to change the password for, press Change password, and enter the new password for that user. Entering an empty string removes the password.

 

Important: MSSQL can use two different authentication modes to be selected during setup: Windows Authentication mode and mixed mode. Windows Authentication mode enables Windows Authentication and disables SQL Server Authentication. Mixed mode enables both Windows Authentication and SQL Server Authentication. When using SQL Server Authentication, logins are created in SQL Server that are not based on Windows user accounts. Both the user name and the password are created by using SQL Server and stored in SQL Server. Users connecting using SQL Server Authentication must provide their credentials (login and password) every time that they connect. Please note that ASQLPR only supports databases that use mixed mode, i.e. SQL Server Authentication.