I want the password field in my users db encrypted. Best way to do this?

Using classic asp and ms sql 2008

thanks

Hi Dave,

SQL server does not offer the possibility for encrypting the content of fields. If you would like to store encrypted information in your database, you'd have to make sure the encryption takes place before the info is saved in the DB.

Kind regards, Patrick

so derive my own algorithm and run passwords through it going into and out of the db? thats what i as afraid of...not a big deal...just more coding than i was hoping for

thanks!

Hi Dave,

Just Google for "SQL encrypted field". I came across multiple freeware encryption possibilities. Good luck!

Kind regards, Patrick