Retrieve a password from SQL

SVA 86 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.
11,589 questions
0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rahul Randive 5,656 Reputation points Microsoft Employee
    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 36,091 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 11,876 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