Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've been tasked with encrypting several years worth of sensitive data (don't ask) stored in a SQL Server 2000 Database. I need to encrypt both historical data and come up with a process to encrypt and decrypt new data as it flows through the system.

Most of the solutions out there seem to use extened stored procedures that call dlls that must be installed on the server.

The best I've seen so far is here, the tools are free but you have to register at the site.

Are there any better solutions out there?

share|improve this question
    
This is probably a Stack Overflow question. –  Evan Anderson Jul 9 '09 at 19:11
    
I wasn't sure, as it may involve adding libraries to an SQL Server instance, it seemed more Server Fault-ish? –  TGnat Jul 9 '09 at 19:16

4 Answers 4

Why not upgrade to sql 2008? Encryption is now built in and you'll get better performance on the same hardware.

share|improve this answer

There's nothing native in SQL Server 2000 that you can use. Anything that you find will have an extended stored procedure which will need to be installed on the system in order to work.

share|improve this answer

How about ROT13 twice... for double protection?

http://en.wikipedia.org/wiki/ROT13

LOL... sorry... couldn't resist. ;-)

On a more serious note... are you trying to encrypt/decrypt in the SQL server itself, or are you planning on doing the encrypt/decrypt at the application level?

I know there are various solutions out there for SQL Server 2005 and 2008 but since you have SQL 2000 you might just find that doing it at the application level is less of a headache.

share|improve this answer
    
As some of the processes run on different platforms (that I don't have control over) an application level solution seems unlikely. –  TGnat Jul 9 '09 at 19:46

You may want to use Protegrity. I have used it successfully in a project and am quite happy with it.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.