How to reset the password of SA account?

Rick2022 41 Reputation points
2023-06-01T08:47:08.22+00:00

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.

User's image

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,348 questions
0 comments No comments
{count} votes

1 additional answer

Sort by: Most helpful
  1. Alok Jha 0 Reputation points
    2024-06-06T17:55:43.83+00:00

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

    0 comments No comments