How to force users to use encrypted connection when creating a new SQL Server data source using Information Designer

How to force users to use encrypted connection when creating a new SQL Server data source using Information Designer

book

Article ID: KB0075243

calendar_today

Updated On:

Products Versions
Spotfire Server All Versions

Description

This article explains a way to enforce encryption, that is when users create a new SQL data source using “Information Designer”.

We can enforce this encrypted connection via "Data Source Template" configuration for SQL data source template.

Note: It is applicable to SQL Server Native driver only.

Issue/Introduction

How to force users to use encrypted connection when creating a new SQL data source using Information Designer?

Environment

All Supported OS

Resolution

You can achieve this by adding below connection properties as part of SQL data source template: 
<connection-properties>
    <connection-property>
      <key>encrypt</key>
      <value>true</value>
    </connection-property>
    <connection-property>
      <key>trustServerCertificate</key>
      <value>true</value>
    </connection-property>
  </connection-properties>

You can read more about properties "encrypt" and "trustServerCertificate" on below Microsoft link:

https://docs.microsoft.com/en-us/sql/connect/jdbc/setting-the-connection-properties?view=sql-server-ver15
Powered by Wolken Software