Home > Resources > Password > SQL Server Forgot SA Password

How to Correct SQL Login Failed Error after SA Password Forgot

SQL Server 2015/2008/2012/2014 forgot SA password for logon? How to correct this error and make SQL Server login successful?

forgot SQL Server SA password

Want to get a good answer? Now think about following questions one by one first.

  1. Question 1: Could I try another way to login SQL Server?
  2. Question 2: Could I use another account to login SQL Server?
  3. Question 3: Could I recover forgotten SQL SA password?
  4. Question 4: Which password recovery tool could help recover or reset SQL SA password effectively?

Q1: Could I try another way to login SQL Server?

As is known, there are two kinds of authentication modes when we login SQL Server, Windows Authentication mode and SQL Server Authentication mode. SA password is only available in SQL Server Authentication mode. So after forgot SA password, we could try Windows Authentication mode. It requires local Windows administrative privileges only.

Choose Windows Authentication mode on SQL Server logon window, and connect to SQL database.

Tips: How to Change SQL Server Authentication Mode

login SQL Server with Windows Authentication mode

Q2: Could I use another account to login SQL Server?

Besides SA account, other user accounts with sysadmin privileges also could be used to login SQL Server. When SQL SA password is forgotten, select SQL Server Authentication mode on logon screen, and choose a user with sysadmin privileges and type its password. At last, click "Connect" button to access SQL Server database.

However, above two methods couldn’t correct SQL Server login failed error. If not, you should find whether there is another way to recover forgotten SQL SA password.

login SQL Server with another sysadmin user

Q3: Could I recover forgotten SQL SA password?

When you are trying to search the Internet and seek for answers to "forgot SQL SA password" or "recover SQL SA password", you would see a variety of tools are designed to recover or reset SQL SA forgotten or lost password for all versions of Microsoft SQL Server. So don’t worry there is no tools for SQL SA password recovery.

Q4: Which password recovery tool could help recover or reset SQL SA password effectively?

SQL Password Genius is one of such effecitve recovery tools for forgotten SQL SA password reset. Take and install it on computer.

1. Run it and then import SQL Server master database by clicking "Open File" button.

2. Select "sa" account in database user list, click "Reset" button, and type new password in new pop-up window.
Confirm SA password reset, and start SQL Server Services, you would login SQL Server with SA account and new password successfully.

reset SQL Server forgotten SA password

Something should be paid attention:

Related Articles:

Quick Links

Password Recovery Software

Windows Password Tools
Windows Password Genius
Office Password Tools
Office Password Genius
Office Password Remover
Word Password Genius
Word Password Remover
Excel Password Genius
Excel Password Remover
PowerPoint Password Genius
Access Password Genius
Outlook Password Genius
SQL Password Genius
Archive Password Tools
RAR Password Genius
ZIP Password Genius
PDF Password Tools
PDF Password Genius

Hot Products