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
IT Analytics is accessing multiple CMDB's
Server OS is Windows 2012 R2 across all servers
Windows 2012 R2 does not have the latest ODBC drivers that support TLS 1.2.
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