I have lost SQL password. What are my options to reset, or add an account?

Willie, Joe 0 Reputation points
2024-12-23T20:20:55.61+00:00

Hello, I am running SQL Server Management Studio: 15.0.18131.0 but I can't make any changes because I don't know the password. I can access it and see the databases and everything is working but I need to make some changes, like upgrading SolarWinds Network monitoring. I am a domain admin on our network and I have access to everything else. This server isn't accessed that often and the previous admin didn't provide a password with the admin credentials.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,213 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
13,476 questions
{count} vote

2 answers

Sort by: Most helpful
  1. Marcin Policht 29,650 Reputation points MVP
    2024-12-23T20:31:23.2666667+00:00

    Follow https://www.sqlshack.com/recover-lost-sa-password/


    If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

    hth

    Marcin

    0 comments No comments

  2. ZoeHui-MSFT 38,871 Reputation points
    2024-12-24T01:40:08.3633333+00:00

    Hi @Willie, Joe,

    Here is a same thread you may take a reference to.

    Forgot SQL Server Password

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.