Re: Decrypt user passwords

From: BP Margolin (bpmargo@attglobal.net)
Date: 03/13/03 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Thu, 13 Mar 2003 17:04:50 -0500

Charlie,

I believe that if you search the Internet you should be able to find code that will decrypt SQL Server 7.0 passwords. I know for a fact that the encryption algorithm used by SQL Server when the WITH ENCRYPTION option is used on stored procedures and views has been broken, and the code is available on the Internet. I believe that the same is true for the encryption method used for passwords, but I wouldn't absolutely swear to it.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Charlie" <cdeaton@corp.realcomp.com> wrote in message news:#o#3xKY6CHA.1784@TK2MSFTNGP10.phx.gbl...
> Is there any way to decrypt login and or user passwords in SQL7. I need to
> create a list of passwords and need help, if it can be done. I have created
> the sp_help_revlogin procedure and ran it but the password are strings. I
> converted the strings to varbinary but now what? I have found a few decrypt
> scripts but they are not working.
>
> Thanks
> Charlie
>
>