By Hally | Last Updated
SQL Server 2005/2008/2012/2014/2016 forgot SA password for logon? How to correct this error and make SQL Server login successful?
Want to get a good answer? Now think about following questions one by one first.
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
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.
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.
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.
Something should be paid attention:
Related Articles:
