Passwords for the logins

Hi All,
Sql server 7
There are set of logins in sql server some are NT
authentication and some are sql server
authentication. How can i retrieve the passwords for both
these logins.
TIA
AdilHaseeb,
the nearest you can do is to extract the password in encrypted format for
SQL logins (only):
SELECT CONVERT(VARBINARY(32), password)
FROM syslogins
WHERE name = 'Margaret'
This can be useful to transfer logins from one server to another.
HTH,
Paul Ibison|||Hi,
You can not retrive the passwords of users in clear text. Only way is to
change the password.
For OS level. You have to change in OS level users password.
For SQL Srever, use enterprise manager or sp_password command from query
analyzer to change the password.
Thanks
Hari
MCDBA
"haseeb" <anonymous@.discussions.microsoft.com> wrote in message
news:16a3b01c447f9$9a5e0be0$a101280a@.phx
.gbl...
> Hi All,
> Sql server 7
> There are set of logins in sql server some are NT
> authentication and some are sql server
> authentication. How can i retrieve the passwords for both
> these logins.
>
> TIA
> Adil|||You can't.
The NT logins are the domain user accounts.
The SQL logins are ones that were created by an sql admin. Probably used by
an specific application. You could back track to the app and get the
password.
"haseeb" <anonymous@.discussions.microsoft.com> wrote in message
news:16a3b01c447f9$9a5e0be0$a101280a@.phx
.gbl...
> Hi All,
> Sql server 7
> There are set of logins in sql server some are NT
> authentication and some are sql server
> authentication. How can i retrieve the passwords for both
> these logins.
>
> TIA
> Adil