Click here to monitor SSC
SQLServerCentral is supported by Redgate
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: Tuesday, March 29, 2016 10:39 AM
Points: 942, Visits: 1,089
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: Sunday, November 27, 2016 3:24 PM
Points: 195, Visits: 3,877
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