store data encrypted in MS SQL server

[bdina]

I am scripting for a website and would like to store data inside a MS SQL Server encrypted. What I am storing is sensitive data (ie. passwords) and would not like plain text stored in the tables. We are using IIS 5.0/VBscript 6.0 and MS SQL 2000 for our platform.

thanks!
--Bryan

 

[ChrisHirst]

Use a SHA-256 Digest for encrypting passwords. An include file available here,

http://www.frez.co.uk/freecode.htm#sha256

Chris.

Indifference will be the downfall of mankind, but who cares?

 

[bdina]

so I just include the asp file, and run the passwords through the sha256()?

Currently I have been inserting the passwords into the database by hand using the MS SQL Enterprise Manager, so I will need to set up a statement to insert the passwords to the database while running them through the sha256(), and then when logging in, do the same correct?

thanks,
--Bryan

 

[ChrisHirst]

basically, that's it.



Chris.

Indifference will be the downfall of mankind, but who cares?

 

[bdina]

yeah, awesome, worked like a charm!

thanks!!
--Bryan