Share via

Retrieve a password from SQL

SVA 116 Reputation points
2023-10-30T11:41:55.2166667+00:00

How to retrieve a password from SQL

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,147 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. RahulRandive 9,901 Reputation points
    2023-10-30T13:07:25.8266667+00:00

    Hi @SVA

    Even Microsoft does not have access to previous passwords and the server admin cannot retrieve them. If you've forgotten the password for the Server Admin, you can reset.

    Found a blog on how to recover SA password by starting SQL Server in single user mode when you forget “sa” credentials or lose the access https://www.sqlshack.com/recover-lost-sa-password/

    Thank you!

    1 person found this answer helpful.
    0 comments
  2. Olaf Helper 45,291 Reputation points
    2023-10-30T11:55:54.1+00:00

    SQL Server don't store passwords in clear text, so you can't get the pwd.

    Ask the DBA to reset the password.

    0 comments
  3. PercyTang-MSFT 12,501 Reputation points Microsoft Vendor
    2023-10-31T01:50:12.6066667+00:00

    Hi @SVA

    Can you describe the background?

    What is the authentication mode and the level of access you have?

    If you forgot the password, you can refer to Rahul's link.

    Best regards,

    Percy Tang

    0 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.