Retrieve a password from SQL

Question

How to retrieve a password from SQL

Answer 1

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!

Answer 2

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

Ask the DBA to reset the password.

Answer 3

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