how to fetch user password

Question

I am a DBA.I am connected to sqlserver 2005 using 'sa' account.
I want to fetch the password of a user.
how to do so?

Answer 1

I am a DBA.I am connected to sqlserver 2005 using 'sa' account.
I want to fetch the password of a user.
how to do so?

SELECT NAME,PASSWORD
FROM SYSLOGINS
WHERE NAME = 'SA'

Thanks,
Mayur

Answer 2

thank...
but the password is encrypted.
how to decrypt it?

moreover how we can one see the password of any  user other than 'sa'?

Answer 3

thank...
but the password is encrypted.
how to decrypt it?

moreover how we can one see the password of any  user other than 'sa'?

There is not way to decrypt the password.
No third party tool is available to fetch the password.
If you get any such information related to fetching the password then kindly update me on [e-mail]

Thanks,
Mayur

Answer 4

you ca also use these 2 views for SQL2005 and SQL2008. 1. sys.server_principals 2. sys.sql_logins but for the password, it's hard and can't to see.

Answer 5

1 workaround is to reset the password by deleting the password field in the msdb, then reset a new one.