How to recover lost or forget administrator SA Password In SQL Server?

I am going to show you how to recover Sysadmin Password through SSMS:-

Kindly follow the below Steps:

1. Stop the SQL server agent
2. Take the SQL server in single user mode

All programs –> SQL server 2012 –> Configuration Tools –> SQL server configuration manager

Stop the agent and take the SQL server into single user mode.

3. Reboot the SQL service

4. Open the SSMS and don’t click the connect button, you need to cancel it and then click on “New query” window on top of the SSMS and then connect.

Note:- If we click on connect button then  object explorer will take one connection & Single user mode allow only one connection Because of that we need to cancel and click the new query window.

Note: You need to be an OS administrator.

5. Create a new login and add as Sysadmin

CREATE LOGIN New_Login_Name WITH PASSWORD =’Strong password’

Exec SP_ADDSRVROLEMEMBER ‘New_Login_Name’,’SYSADMIN’


Hope it will help you guys!!!