How to resolve "SSL Security Error" while using SQL Server with TLS 1.2 encryption ? This error may be encountered either while querying a SQL Server with TLS1.2 encryption or while using SQL Server with TLS 1.2 as meta database for Statistica installation.



Cause : The currently deployed Microsoft OLE DEB Providers for SQL may not support TLS 1.2 yet.  Please refer to Microsoft the SQL Server versions that support TLS 1.2:  https://support.microsoft.com/en-us/kb/3135244 

1. If not already installed, download and install -  Microsoft OLE DB Driver 18.1 for SQL Server from :  https://docs.microsoft.com/en-us/sql/connect/oledb/download-oledb-driver-for-sql-server?view=sql-server-2017

2. On the Data Link Properties dialog prompted by the installer (or while creating a database connection), choose the new Microsoft OLEDB Driver for SQL Server (vs the Microsoft OLEDB Provider for SQL Server)



3.  Enter the server details for the SQL Server database with TLS 1.2 enabled and Test Connection.



The installer/ Database connection can proceed as usual then.
 

How to resolve "SSL Security Error" while using SQL Server with TLS 1.2 encryption in TIBCO Statistica?

https://support.microsoft.com/en-us/kb/3135244 
https://support.tibco.com/s/article/What-SQL-Server-ODBC-driver-should-be-used-when-TLS-version-1-2-is-enabled