How to recover SA password

Question

Hello all,

I have only rights access in my Windows authentication , i dont remember SA password also and i need to access database from SA authentication, i tried a to recover SA password a lot but no luck, I am not able to do any thing from windows authentication.

How can i re-set password for SA account and grant admin rights to both SA and windows users.

Your help would be appreciate!

Br,

Abhi14

---

Ruchi

Answer 1

Hello,

If you are member of Local Windows administrator group, you can change the sa password by starting the SQL Server in single mode option. You can read this:
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/connect-to-sql-server-when-system-administrators-are-locked-out?view=sql-server-2017

Regards,
Rafael

Answer 2

 Hi Abhi1410,

Did you follow the steps from the link that PAfael provide and  resolve your issue? If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.

In addition, if you have another questions, please feel free to ask.
Thanks for your contribution.

Best regards,
Cathy

---

MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact [e-mail]