TDE implementation on sql 2016 version

• DBA

  Old Hand

  Points: 371

  More actions

  January 31, 2022 at 6:01 pm

  Go to Answer

  #3979286

  Hi,

  I'm implementing TDE for first time I researched below steps are what it takes. However, is there any detailed demo on this or what are prerequistes to keep in mind? Please let me know thanks

  Create a master key.

  Create or obtain a certificate protected by the master key.

  Create a database encryption key and protect it by using the certificate.

  Set the database to use encryption

   

  • This topic was modified 2 years, 10 months ago by  DBA.

• Arun Yadav

  Ten Centuries

  Points: 1289

  More actions

  January 31, 2022 at 6:49 pm

  Answer

  #3979303

  Hello,

  Please check the below articles:

  https://docs.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver15

  https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/encrypting-sql-server-transparent-data-encryption-tde/

  https://support.delphix.com/Delphix_Virtualization_Engine/MSSQL_Server/Setting_Up_SQL_Server_Transparent_Data_Encryption_(TDE)_For_Use_With_The_Delphix_Engine_(KBA1401)

   

• DBA

  Old Hand

  Points: 371

  More actions

  February 14, 2022 at 5:53 am

  #3983199

  Thanks for sharing.

  • This reply was modified 2 years, 10 months ago by  DBA.