Remove SQL Server Password

How to Remove Password from SQL Server

Time and time again, you try so hard to remove SQL Server password because you urgently read the password-protected data. However, you failed because you don't remember your own password or you even don't know the password because it was set by former colleague. Or the password has expired and your account is disabled. Under such conditions, mere trying is not enough; you need some other more professional ways to help you out.

Here I will show you two ways about how to crack SQL Server password and some knowledge about SQL Server password policy.

How to remove SQL Server password with SQL Password Recovery?

Many methods to crack SQL Server password are rather difficult especially for green hands on computer. You may ask, "Then is there any easy way to recover SQL Server password?" The answer is yes. SQL Server Password Recovery is a smart, easy-to-use and safe SQL Server password cracker designed to recover SA password and any user password in SQL Server 2012/2008(R2)/2005 without any data loss.

Download a Free Trial Version of this software and have a try.

Download SmartKey SQL Password Recovery:

Download, install and run the software on your PC. Then follow the easy steps to break SQL Server password.

• Step1. Click "Open" to load master.mdf file to this software.
  Note: The default master.mdf file location is as follows:
  C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER08\MSSQL\DATA

  

• Step2. Click the account that you want to remove password and then click "Change Password".

  

• Step3. Type a new password and click "OK" to finish.

  

How to recover SQL Server password in Single User Mode

If you are an advanced user of SQL Server, then you can try to crack MS SQL Server password in Single User Mode. If there is other Windows Login that is a member of Windows Admin Group, log in using that account. Follow the procedure as displayed below step by step.

• Step1. Start SQL Server Configuration Manager and click on SQL Server Services. Click on desired SQL Server instance and right click go to properties to stop SQL Server.

  

• Step2. On the "Advanced" table, add ‘-m;' before existing parameters in "Startup Parameters" box.

  

• Step3. Restart SQL Server services and your SQL Server will be running in Single User Mode.
• Step4. Start CMD on the SQL Server and create a new user using following commands.
  CREATE LOGIN recovery WITH PASSWORD = ‘TopSecret 1′ (Remember SQL server has default strong password policy
  Go
• Step5. After this, a user is created. And we have to grant the user a SYSADMIN role using the following commands.
  sp_addsrvrolemember ‘recovery', ‘sysadmin'
  Go
• Step6. Now delete "-m;'' before "-dC". Then restart SQL Server and use the newly created login.
• Step7. After that, change SA password in "Security" panel.

  

Under this condition, you can try the above two methods to help you recover SQL Server password.

SQL Server Password Policy

If you changed your mind and need to create a new password for SQL Server, please obey the SQL Server Password Policy.

Password Complexity

Password complexity policies are designed to deter brute force attacks by increasing the number of possible passwords. When password complexity policy is enforced, new passwords must meet the following guidelines:

• The password does not contain the account name of the user.
• The password is at least eight characters long.
• The password contains characters from three of the following four categories:
  • Latin uppercase letters (A through Z)
  • Latin lowercase letters (a through z)
  • Base 10 digits (0 through 9)
  • Non-alphanumeric characters such as: exclamation point (!), dollar sign ($), number sign (#), or percent (%).

Passwords can be up to 128 characters long. You should use passwords that are as long and complex as possible.

Password Expiration

Password expiration policies are used to manage the lifespan of a password. When SQL Server enforces password expiration policy, users are reminded to change old passwords, and accounts that have expired passwords are disabled.

Download SmartKey SQL Password Recovery:

comments powered by Disqus