April 29, 2009 at 4:48 pm
I have some information that needs to be encrypted. At the same time, it needs to be decrypted for reporting purposes.
I'm looking into using CLR to decrypt the information but the encryption will be done on the client side. Is this feasible?
April 30, 2009 at 6:50 am
I would think you could do this. What is your reporting solution going to be? If I was using SSRS I would decrypt in the report, as you could include the decryption dll in the report.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
April 30, 2009 at 1:04 pm
thats what I was thinking of. Performing the decryption in SSRS.
May 7, 2009 at 8:17 am
(the usual commentary regarding overhead of encryption, etc...)
Why get the client to do the encryption? In SQL Server 2005 + you can use SQL to perform encryption for you.
EncryptByPassPhrase http://technet.microsoft.com/en-us/library/ms190357(SQL.90).aspx and friends can do this for you.
This uses pass phrases and an optional salt, but SQL also supports certificate based encyrption as well.
That'd be much easier than introducing all the issues, and yes overhead, of the CLR within SQL
--
Andrew Hatfield
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply