Retrieve a password from SQL

SVA 86 Reputation points

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 No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Rahul Randive 5,656 Reputation points Microsoft Employee

    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

    Thank you!

    1 person found this answer helpful.
    0 comments No comments

  2. Olaf Helper 36,091 Reputation points

    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 No comments

  3. PercyTang-MSFT 11,876 Reputation points Microsoft Vendor

    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 No comments