Error: "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 the SQL Servers, the following errors were seen:

DBNETLIB ConnectionOpen SECCreateCredentials() SSL Security error.; 08001

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

Environment

ITMS 8.x

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 it will needed to upgrade the driver that we are being used to connect to SQL. Otherwise if you need to use these SQL 2000 drivers, then you will need to keep TLS 1.0 enabled. 

List of available ODBC drivers available and their download location can be found in the following Microsoft ODBC Driver for SQL Server on Windows location:

https://learn.microsoft.com/en-us/sql/connect/odbc/windows/microsoft-odbc-driver-for-sql-server-on-windows?view=sql-server-ver16