How to enable the TLS Database connection

From version 2022.2.0, the TRUECHART service supports a TLS encryption to the Database. This ensures the data being sent from the service to the database is encrypted, providing an additional layer of confidentiality to your data.

To enable this function :

MSSQL

• Ensure your MSSQL server has a certificate for a secure connection, this can be performed by your IT team:
  • In the SQL Server Configuration Manager, view the Properties of the Protocols for your SQL instance 
  • Example seen below with a certificate applied
  • 

MySQL

• MySQL has a certificate applied by default, there is no setup required here.

TRUECHART Setup

• To enable TRUECHART to use the TLS encryption, enable the following two parameters for the xml setup file on the install directory of TRUECHART:
  • ...\High Coordination \ Webapps \ TRUECHARTService \ WEB-INF \ classes \ META-INF \ hicoservice.xml
    • <Encrypt>true</Encrypt>
      <TrustServerCertificate>true</TrustServerCertificate>