Views:

Starting in Dynamics SL 2018 CU1, Transport Data Encryption (TDE) is supported. 

To enable TDE in your Dynamics SL database(s), edit the below script by adding a strong password and entering the appropriate SL database name.  Then, run it in SQL Management Studio. No additional configuration is needed. 

 

USE master;
GO

CREATE MASTER KEY ENCRYPTION BY PASSWORD = '<UseStrongPasswordHere>';
go

CREATE CERTIFICATE MyServerCert WITH SUBJECT = 'My DEK Certificate';
go

USE <Dynamics SL Database name>;
GO

CREATE DATABASE ENCRYPTION KEY
WITH ALGORITHM = AES_128
ENCRYPTION
BY SERVER CERTIFICATE MyServerCert;
GO

ALTER DATABASE <Dynamics SL Database name>
SET ENCRYPTION ON;
GO