Showing posts with label pwdencrypt. Show all posts
Showing posts with label pwdencrypt. Show all posts

Wednesday, March 7, 2012

Password hashes for SQL 7.0 & 2000

hi,
The password hashes generated by pwdencrypt() for SQL7.0 & SQL2000 are
different. The password hash generated for SQL 2000 stores both the actual
passsword & it's upper case version (David Litchfield's article on cracking
SQL passwords). But the passwor hash for SQL 7.0 is of 16 bytes only. I
wanted to use the pwdencrypt() to generate the password hashes but want to
verify the values without sending the 'pwdcompare()' query to server. I
could do it for SQL 2000 but the SQL 7.0 hashes seems to be different.
Thanks.
Ajey.Those undocumented xp shouldn't be used in production. They're not supported
and subject to change by MS without notice (which has been changed in the
past). If you're looking a way to hash your password, take a look at this
udf (courtesy of Steve Kass).
http://groups.google.co.uk/groups?q...58-E7ADEA79360F
-oj
"Ajey" <ajey5@.hotmail.com> wrote in message
news:OuaWKJ2BFHA.2568@.TK2MSFTNGP10.phx.gbl...
> hi,
> The password hashes generated by pwdencrypt() for SQL7.0 & SQL2000 are
> different. The password hash generated for SQL 2000 stores both the actual
> passsword & it's upper case version (David Litchfield's article on
> cracking
> SQL passwords). But the passwor hash for SQL 7.0 is of 16 bytes only. I
> wanted to use the pwdencrypt() to generate the password hashes but want to
> verify the values without sending the 'pwdcompare()' query to server. I
> could do it for SQL 2000 but the SQL 7.0 hashes seems to be different.
> Thanks.
> Ajey.
>

password encryption

I have an Access .adp application and I need to store the passwords encrypted. I see that there are unsupported functions pwdencrypt() and pwdcompare() in SQL server 2K.
Are there any other functions or methods in SQL Server 2000 that could be called that would provide this capability?Are there any other functions or methods in SQL Server 2000 that could be called that would provide this capability?

SQL Server 2000 encryption is pretty weak. 2005 is supposed to address this. In the meantime, you might consider this link:

http://www.sqlservercentral.com/columnists/mcoles/freeencryption.asp

(you may have to register, but registration is free).

Alternatively, you could use the Micrsoft Crypto API (capicom.dll) or the .Net Encryption utilities (don't have more specific references on these).

Regards,

hmscott