How to reset the password of SA account?

Question

I forgot the password of SA user account. When I login with Windows Authetication, try to reset the password and it told me that I do not have permission. The BUILTIN\Users only have public server role. It won't allowed you to add the sysadmin role.

Can somebody tell me how to change the password of SA account? I don't want to reinstall the sql server.

Answer 1

You change anything on the SysAdmin account "sa" you also need admin permissions.

If you have local Windows Admin privileges, the you can try this:

Connect to SQL Server when system administrators are locked out

Answer 2

Click on this video :https://youtu.be/Jr_yVQhb-Ak