Does SQL Native Client driver works with Statistica when TLS 1.2 enabled?

Does SQL Native Client driver works with Statistica when TLS 1.2 enabled?

book

Article ID: KB0073170

calendar_today

Updated On:

Products Versions
Spotfire Statistica 13.3 or higher

Description

This article defines the usage of SQL Native Client driver with Statistica when TLS 1.2 is enabled.

Note: 
1. SQL Native client is not the most recommended driver. Refer to: https://support.tibco.com/s/article/What-SQL-Server-ODBC-driver-should-be-used-when-TLS-version-1-2-is-enabled
2. TLS 1.2 is enabled by default on Windows 10, version 1507+ and Windows Server 2012+.

Issue/Introduction

Does SQL Native Client driver works with Statistica when TLS 1.2 enabled?

Environment

Windows only.

Resolution

The SQL Native client driver works with Statistica when TLS 1.2 is enabled. 

1. Install the compatible version SQL Native Driver. Refer: SQL Native driver
2. Under ODBC Administrator|System DSN, check the driver version for the existing Enterprise database DSN (named "SEWSS" by default). If the old driver (e.g. ODBC Driver 13 for SQL server) is in use, delete the current DSN.
Note: Before deleting, please keep a record of the DSN information such as name and description, since the information is needed in later steps.
3. Click the "Add" button to create a new DSN and select "SQL Server Native Client" as the driver.

User-added image

4. Fill in the same information as the deleted DSN (name and description), and select the same SQL server database:

User-added image

5.  Follow the instruction to finish the DSN setup steps.
When launching Statistica, selecting the correct database in the drop-down, if necessary:

User-added image
 

Additional Information

SQL Server ODBC driver when TLS 1.2 is enabled : https://support.tibco.com/s/article/What-SQL-Server-ODBC-driver-should-be-used-when-TLS-version-1-2-is-enabled
If you are using 2008R2 SQLServer Database, you may need to apply a patch to make TLS work: https://support.microsoft.com/en-us/help/3135244/tls-1-2-support-for-microsoft-sql-server 
How to enable TLS 1.2 on Windows Server 2008/2016 - https://trustzone.com/knowledge-base/how-to-enable-tls-1-2-on-windows-server-2008-2016/ 
How to enable TLS 1.2 on clients - https://docs.microsoft.com/en-us/mem/configmgr/core/plan-design/security/enable-tls-1-2-client
The recommended driver for pulling data MSSQL Server with TLS1.2 enabled is  Microsoft OLEDB Driver for SQL Server: Microsoft OLEDB Driver for SQL Server - with-TLS-1-2-encryption-in-TIBCO-Statistica