SSL Security error.; 08001 when trying to process cubes in IT Analytics.

Products

• IT Management Suite
• Client Management Suite
• IT Analytics

Issue/Introduction

After having TLS 1.0 and 1.1 removed from our SQL Servers, we are having the following errors:

DBNETLIB ConnectionOpen SECCreateCredentials() SSL Security error.; 08001

[Microsoft][ODBC SQL Server Driver][DBNETLIB]SSL Security error

Environment

IT Analytics is accessing multiple CMDB's

Server OS is Windows 2012 R2 across all servers

Cause

Windows 2012 R2 does not have the latest ODBC drivers that support TLS 1.2.

Resolution

This is a common issue when disabling TLS 1.0.  The ODBC drivers that SQL uses are built into Windows, are designed for SQL 2000, and don’t have official support for TLS 1.2.  In order to use TLS 1.2 we will need to upgrade the driver that we are using to connect to SQL. Otherwise if we need to use these SQL 2000 drivers, then we will need to keep TLS 1.0 enabled. 

List of available ODBC drivers available and their download location can be found here:

Microsoft ODBC Driver for SQL Server on Windows
https://learn.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows?view=sql-server-ver16