How to get non sa password in SQL Server?

Question

Can I get (if the user has sa rights) the user password in SQL Server 2008 R2?

The scenario is this: I need to automatically save the list of all usernames and passwords in the document, but without changing the password, just by reading the actual password.

Is this possible or not?

Answer 1

Yes, you can use SQL login.

You read the hashed passwords sys.sql_logins (possibly only through the DAC ) and use a tool like NGS SQLCrack .

However, there was almost never a need to store them in a document.

There is no Windows-based login. The password is in AD.

And read the following: What are the arguments for and against network policy when the sys administrator knows user passwords?