Click here to Skip to main content
15,891,657 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi Forum,

How can i create an assembly to decrypt data in SSRS 2008 R2.
I have encryted data in an Employee table and i need to be able to decreyt the data to print unencrypted values.
I am envrypting the data using a certificate. I can decryt the data in SQL but i want to be able to decrypt it in SSRS.
I am using the following code in SQL.

OPEN SYMMETRIC KEY Emp
DECRYPTION BY CERTIFICATE EmpCert;
GO

Any help will be greatly appreciated...

Regards,

Manuel Roman
Posted
Comments
mroman98 3-Nov-12 13:44pm    
Hi Forum,

How can i create an assembly to decrypt data in SSRS 2008 R2.
I have encryted data in an Employee table and i need to be able to decreyt the data to print unencrypted values.
I am envrypting the data using a certificate. I can decryt the data in SQL but i want to be able to decrypt it in SSRS.
I am using the following code in SQL.

CREATE SYMMETRIC KEY Emp
WITH ALGORITHM = AES_256
ENCRYPTION BY CERTIFICATE EmpCert;
GO

OPEN SYMMETRIC KEY Emp
DECRYPTION BY CERTIFICATE EmpCert;
GO

What need is a funtion to open the Symmetric key and a function or assembly to decrypt the variables i need to print on the report.
I am using ALGORITHM AES_256 as you can see above, where i create the Certificate.

Any help will be greatly appreciated...

Regards,

Manuel Roman

1 solution

 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900