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 12»»

TDE Setup Expand / Collapse
Author
Message
Posted Thursday, July 25, 2013 10:32 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:11 PM
Points: 31,368, Visits: 15,837
Comments posted to this topic are about the item TDE Setup






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1477846
Posted Thursday, July 25, 2013 10:45 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: 2 days ago @ 3:20 PM
Points: 18,064, Visits: 16,099
Nice and easy - thanks Steve.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1477852
Posted Thursday, July 25, 2013 11:00 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, December 2, 2014 9:20 AM
Points: 1,372, Visits: 1,567
SQLRNNR (7/25/2013)
Nice and easy - thanks Steve.


+1


~ Lokesh Vij

Guidelines for quicker answers on T-SQL question
Guidelines for answers on Performance questions

Link to my Blog Post --> www.SQLPathy.com

Follow me @Twitter

Post #1477856
Posted Thursday, July 25, 2013 11:20 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, February 6, 2014 4:15 AM
Points: 1,242, Visits: 1,546
Good one !!!



Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!
www.GrowWithSql.com

Post #1477862
Posted Friday, July 26, 2013 1:08 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Thursday, December 18, 2014 12:52 PM
Points: 13,636, Visits: 11,509
TDE isn't my strong suit. Ah well, it's almost weekend



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1477885
Posted Friday, July 26, 2013 2:59 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, December 15, 2014 4:15 AM
Points: 5,471, Visits: 1,402
Nice one.


Post #1477910
Posted Friday, July 26, 2013 7:41 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 10:51 AM
Points: 4,158, Visits: 5,556
Interesting series of questions around TDE, thanks Steve.

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1478009
Posted Friday, July 26, 2013 7:44 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:37 PM
Points: 351, Visits: 316
Nice question that should have been easy.
Should have read it slower I guess.

You create and store the Certificates in master.

You have to be connected to the CRM to USE the certificate to protect the DEK.
Post #1478011
Posted Friday, July 26, 2013 8:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 4:36 PM
Points: 6,133, Visits: 8,398
I got it right, because I know that you have to create a certificate in master to protect the master key - but the question is a bit misleading.

The question says: "You have created a master key already in the master database and in the CRM database".
First, you do not create a master key in the CRM database. The master key is in the master database only. The key in the CRM database is called a "database encryption key" (DEK).
Second, I don't even think it's possible to create the DEK in the CRM database without FIRST creating the certificate. Since you need this certificate when you create the DEK.



Hugo Kornelis, SQL Server MVP
Visit my SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis
Post #1478034
Posted Friday, July 26, 2013 8:30 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 12, 2014 1:37 PM
Points: 351, Visits: 316
Hugo Kornelis (7/26/2013)
I got it right, because I know that you have to create a certificate in master to protect the master key - but the question is a bit misleading.

The question says: "You have created a master key already in the master database and in the CRM database".
First, you do not create a master key in the CRM database. The master key is in the master database only. The key in the CRM database is called a "database encryption key" (DEK).
Second, I don't even think it's possible to create the DEK in the CRM database without FIRST creating the certificate. Since you need this certificate when you create the DEK.


Glad to know it was not just me... Still a good question Steve.
Post #1478039
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse