Tuesday, February 28, 2012 8:43 PMI am looking to implement TDE and would like to know if the certificate used to secure the database encryption key can be a trusted certificate? If so how would you go about generating and using it with TDE?
Wednesday, February 29, 2012 3:56 AMhttp://derek858.blogspot.com/2010/07/sql-2008-r2-generate-trusted-tde.html
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
- Marked As Answer by MaryA2010 Friday, March 02, 2012 10:20 PM
Wednesday, February 29, 2012 4:11 AM
Please use Mark as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
Thursday, March 01, 2012 7:39 AMModerator
Please refer to these Microsoft articles:
The first article contains using the certificate with TDE and the second article contains the introduction of SQL Server certificate and how to generate a certificate.
If anything unclear, please feel free to let me know.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.