Optional procedure: Enabling / disabling database encryption

This topic explains how to enable and disable database encryption modifying an existing OD variable with new property values.

Transform variable Action
EDSTransformVar Add new property
  • <Property Id="SQLDBOPTIONS" Value="Integrated Security=true; Encrypt=true; TrustServerCertificate=true;"/>
DocViewerTransformVar Update or add property
  • <Property Id="DOCVIEWERINTERFACE_HTML_SQLSESSIONSTATECRED" Value="Integrated Security=true; Encrypt=true; TrustServerCertificate=true;"/>
DGSCoreTransformVar Update property
  • Encrypt=true; TrustServerCertificate=true; to DGSCORE.DGSCONNECTIONSTRING <Property Id="DGSCORE.DGSCONNECTIONSTRING" Value="data source=labw6416hvm194.wkmnlab.net;Initial Catalog=DocGen;Integrated Security=true; Encrypt=true; TrustServerCertificate=true;" Secure="yes"/>
DGSTransformVar Update the following properties:
  • <Property Id="SECURITYTOKENCACHEDB" Value="Server=#{DBServer};database=AppSecurityTokenCache;Integrated Security=True; Encrypt=true; TrustServerCertificate=true;"/>
  • <Property Id="SHORTTERMSQLSERVERHOSTNAME" Value="Data Source=#{DBServer};Initial Catalog=docgen;Integrated Security=true; Encrypt=true; TrustServerCertificate=true;"/>