SQL server 2005 Encryption

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Security » SQL server 2005 Encryption

SQL server 2005 Encryption

Rate Topic

Display Mode

Topic Options

Author

Message

ray carmody

Posted Tuesday, March 17, 2009 10:24 AM

Grasshopper

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

Mohit K. Gupta

Posted Wednesday, March 18, 2009 12:38 AM

SSC Eights!

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:37 PM
Points: 941, Visits: 1,041

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. Smooooth

How to ask for help .. Read Best Practices here.

Post #678144

Satheesh E.P.

Posted Monday, March 23, 2009 3:29 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, October 18, 2012 4:36 AM
Points: 173, Visits: 3,732

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 »

Permissions