Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQL server 2005 Encryption Expand / Collapse
Posted Tuesday, March 17, 2009 10:24 AM


Group: General Forum Members
Last Login: Wednesday, September 22, 2010 5:05 AM
Points: 13, Visits: 57

A client has requested that we encrypt our warehouse database using a aes128 key..

how easy is this to do...also if we have cognos reading this assume the select statements will need to have a decrypt statement also..

So any ideas on how to do this?



Post #677672
Posted Wednesday, March 18, 2009 12:38 AM

SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, November 23, 2015 10:57 PM
Points: 942, Visits: 1,082
Have a read at ..

Gives you basics..

Have a read at ..

for Encryption Overview.



Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE

* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.

How to ask for help .. Read Best Practices here.
Post #678144
Posted Monday, March 23, 2009 3:29 PM



Group: General Forum Members
Last Login: Monday, October 12, 2015 3:38 PM
Points: 191, Visits: 3,849
You can try Symmetric Key Encryption since you are using it in warehouse. Symmetric key is good in performance.

Refer this article,

Post #681910
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse