How to force users to use encrypted connection when creating a new SQL Server data source using Information Designer
Article ID: KB0075243
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.
Environment
All Supported OS
Resolution
You can achieve this by adding below connection properties as part of SQL data source template:
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
<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
Issue/Introduction
How to force users to use encrypted connection when creating a new SQL data source using Information Designer?
Feedback
Yes
No
Powered by
