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
Author
Message
Posted Tuesday, March 17, 2009 10:24 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

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 wh..so assume the select statements will need to have a decrypt statement also..

So any ideas on how to do this?

Regards

Ray

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: Saturday, August 23, 2014 10:43 AM
Points: 942, Visits: 1,064
Have a read at ..

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

Gives you basics..

Have a read at ..

http://msdn.microsoft.com/en-us/library/ms189586(SQL.90).aspx

for Encryption Overview.

Thanks.


---

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


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, September 23, 2014 4:48 AM
Points: 190, Visits: 3,837
You can try Symmetric Key Encryption since you are using it in warehouse. Symmetric key is good in performance.

Refer this article,
http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx


---------------------------------------------------
Thanks,
Satheesh.
Post #681910
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse