When carelessly lost SA password and cannot connect to server, you can reset SA password easily by login with Windows Authentication. The problem is when Windows Authentication was disabled or you failed to login with Windows Authentication, how to reset SA password and recover your SA user.
Some people may thought it should be impossible to reset SA password when SQL Server lost SA password and Windows Authentication was also unavailable, and the only option is to reinstall SQL Server and get a new SA user.
Absolutely not, you can reset SQL Server SA password without any login. Let’s have a look at how to perform.
Step 1: Stop SQL Server services
It is very important to firstly stop all services in SQL Server before you start to reset SA password.
Just open SQL Server Configuration Manager to stop SQL Server services.