March 17, 2009 at 10:24 am
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
March 18, 2009 at 12:38 am
Have a read at ..
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[/url].
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. :smooooth:[/font]
March 23, 2009 at 3:29 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply