Encryption/Decryption Utility in SQL Server 2000

Hi,

I would like to know if SQL Server 2000 has any encryption/decryption utilities that we could use. I have a situation where I need to store the password into a database table. But I want to store this as an encrypted value.

We cannot use any third party encryption tools for this purpose.

Any help is greatly appreciated.

Thanks
Raj

Yes there is a password encrypt function - PWDENCRYPT(). This stores the password as a one-way hash. Use PWDCOMPARE() to compare the users entered data with their stored password.

If a user forgets their password, you will need a simple random password generator to reset their password. You would email them the randomly generated password and reset their current password to this generated password which should be run through the PWDENCRYPT() function. Of course you will email it to them in plain text.

I like to set a flag in the user table which enforces a rule forcing the user to HAVE to change thier password before loggin back on.

Hi Stumpy,
Tried this suggestion but could not find the functions pwdencrypt and pwdcompare in SQL Sever 2000. Which database and version do these functions belong to?

Thanks for your interest in helping. Waiting for your reply.

Thanks
Raj

Once again, google has the answer... it really is the best place to look.

e.g.
http://www.winnetmag.com/Articles/I...m?ArticleID=102
http://www.transactsql.com/statement/PWDCOMPARE.html
http://www.experts-exchange.com/Dat...Q_20698196.html
http://www.experts-exchange.com/Dat...Q_20606901.html
http://dbforums.com/arch/7/2002/9/326891