SQL Server 2000 Encryption Tools

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Press Release » SQL Server 2000 Encryption Tools

SQL Server 2000 Encryption Tools

Rate Topic

Display Mode

Topic Options

Author

Message

Andy Warren

Posted Saturday, March 25, 2006 10:32 AM

SSCertifiable

Group: Moderators
Last Login: Tuesday, June 11, 2013 6:34 AM
Points: 6,463, Visits: 1,388

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/pressrelease/sqlserver2000encryptiontools.asp

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #268455

tushkieeeee

Posted Tuesday, July 07, 2009 10:44 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, June 06, 2013 6:54 AM
Points: 103, Visits: 411

Hi,
I am working on SQL Server 2000 and I have a table containing a password field. I have to add a new column to the table and convert all the exisiting password fileds to encripted password exploiting sha256 algorithm. CAn you help me with any stored procedure or extended stored procedure.

Thanks,
Tushar

Post #748723

Elliott Whitlow

Posted Tuesday, July 07, 2009 11:33 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 4:39 PM
Points: 5,861, Visits: 4,884

First of all you cannot implement (without EXTREME PAIN) sha256 in a stored procedure..

With that said however, you can get an extended stored procedure that that can handle it, I found one for you at:
http://anmar.eu.org/projects/ctnhashproc/

As I see it, you create an additional column, hash the passwords into it and then delete the previous password column. Make sure that whatever you use in your apps to hash the entered password that it creates hashes that are the same, they may both be sha256 but you never know who might have screwed up..

Clear?

CEWII

Post #748748

« Prev Topic | Next Topic »

Permissions