sqlserver probe connection error after TLS 1.2 upgrade SECCreateCredentials

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

After the upgrade of TLS where TLS 1.0 is disabled and TLS 1.1/ 1.2 enabled but facing odbc drivers connection error while trying to connect to the database from the probe.

The below is the error we are facing:

sqlserver: Profile: test connection profile/test connection checkpoint/Connect - DB Provider: Code=0x80004005 Source=Microsoft OLE DB Provider for ODBC Drivers Description=[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (SECCreateCredentials()).

Environment

• UIM 20.3 or higher
• sqlserver probe 5.42 or higher

Resolution

Enable the FIPS parameter on the servers where you are facing the issue. FIPS should be enabled, because by default it is disabled.

Please refer to the following link for enabling FIPS:
https://ashwaniashwin.wordpress.com/tag/dbnetlib/ 

It is recommended to use sqlserver probe 5.42 or higher. (At the time of this writing 5.42 is the highest available version.)

Also Please make sure MS Native client 11 is installed on robot where sqlserver probe is deployed.
https://www.microsoft.com/en-us/download/details.aspx?id=50402