DX IM - UIM - sqlserver probe - not connecting

Products

DX Infrastructure Management

Issue/Introduction

We just see this messages at the sqlserver.log:

Mar 12 18:37:47:161 [13756] sqlserver: ciOpen - cache path: C:\Program Files (x86)\Nimsoft\niscache
Mar 12 18:37:47:161 [13756] sqlserver: ciGetDeviceIdentifiers - COLEQADB found (remote device) [D40999DDD7713FDD712FD249FB33C876E]
Mar 12 18:37:47:161 [13756] sqlserver: ciClose - [CC5BF8259EB65B230878F74EDF86C44B2]
Mar 12 18:38:17:163 [13756] sqlserver: Profile timeout checked
Mar 12 18:38:17:163 [13756] sqlserver: (checkTimeout) - ciOpenRemoteDevice->hostname-> [],p->pconn->address-> [COLEQADB]
Mar 12 18:38:17:163 [13756] sqlserver: ciOpen - cache path: C:\Program Files (x86)\Nimsoft\niscache
Mar 12 18:38:17:163 [13756] sqlserver: ciGetDeviceIdentifiers - COLEQADB found (remote device) [D40999DDD7713FDD712FD249FB33C876E]
Mar 12 18:38:17:163 [13756] sqlserver: ciClose - [CC5BF8259EB65B230878F74EDF86C44B2]
Mar 12 18:38:47:164 [13756] sqlserver: Profile timeout checked
Mar 12 18:38:47:164 [13756] sqlserver: (checkTimeout) - ciOpenRemoteDevice->hostname-> [],p->pconn->address-> [COLEQADB]
Mar 12 18:38:47:164 [13756] sqlserver: ciOpen - cache path: C:\Program Files (x86)\Nimsoft\niscache
Mar 12 18:38:47:164 [13756] sqlserver: ciGetDeviceIdentifiers - COLEQADB found (remote device) [D40999DDD7713FDD712FD249FB33C876E]
Mar 12 18:38:47:164 [13756] sqlserver: ciClose - [CC5BF8259EB65B230878F74EDF86C44B2]
Mar 12 18:38:51:946 [13756] sqlserver: RREQUEST: check_connection <-10.50.60.15/57455 h=323 d=172
Mar 12 18:38:51:946 [13756] sqlserver: check_connection; from 10.50.60.15/57455, service name: COLEQADB, user: COLEQADB\sqlmon, winauth: 1, encrpytion: 0, timeout: 300
Mar 12 18:38:51:946 [13756] sqlserver: testClient starting with: user: COLEQADB\sqlmon, conn: COLEQADB
Mar 12 18:38:51:946 [13756] sqlserver: Profile: test connection profile, data engine connecting to database COLEQADB, using connection test connection, user: COLEQADB\sqlmon, winauth: 1, encr: 0, tls_enable: 0
Mar 12 18:38:51:946 [13756] sqlserver: (CreateConnString) Starting for profile - test connection profile
Mar 12 18:38:51:946 [13756] sqlserver: ptConn->ntauth=1, [0][][COLEQADB][(null)]
Mar 12 18:38:51:946 [13756] sqlserver: (CreateConnString) Provider=MSDASQL;Driver={SQL Server};Database=master;Server=COLEQADB;Trusted_Connection=yes
Mar 12 18:38:51:946 [13756] sqlserver: Profile: test connection profile/test connection checkpoint, domain logon using user COLEQADB\sqlmon...
Mar 12 18:42:47:099 [13384] sqlserver: Profile COLEQADB, Connect - connection timeout after 300 sec
Mar 12 18:43:52:058 [13756] 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][Shared Memory]ConnectionOpen (SECCreateCredentials()).
Mar 12 18:43:52:058 [13756] sqlserver: Connection test to COLEQADB failed
Mar 12 18:43:52:058 [13756] sqlserver: sockWrite Failed: 000000AB9F83F050 10.50.60.15/57455 10053 (rc = -1, sfd = 1516, lenleft = 364)
Mar 12 18:43:52:058 [13756] sqlserver: nimISend: failed to write 364 bytes (rc=-1) [single buffer]
Mar 12 18:43:52:058 [13756] sqlserver: SREPLY: status = 0(OK) ->10.50.60.15/57455
Mar 12 18:43:52:058 [13756] sqlserver: head mtype=200 status=0 seq=0
Mar 12 18:43:52:058 [13756] sqlserver: Profile timeout checked
Mar 12 18:43:52:058 [13756] sqlserver: (checkTimeout) - ciOpenRemoteDevice->hostname-> [],p->pconn->address-> [COLEQADB]
Mar 12 18:43:52:058 [13756] sqlserver: ciOpen - cache path: C:\Program Files (x86)\Nimsoft\niscache
Mar 12 18:43:52:058 [13756] sqlserver: ciGetDeviceIdentifiers - COLEQADB found (remote device) [D40999DDD7713FDD712FD249FB33C876E]
Mar 12 18:43:52:058 [13756] sqlserver: ciClose - [CC5BF8259EB65B230878F74EDF86C44B2]
Mar 12 18:43:52:058 [13756] sqlserver: RREQUEST: check_connection <-10.50.60.15/59204 h=323 d=168
Mar 12 18:43:52:058 [13756] sqlserver: check_connection; from 10.50.60.15/59204, service name: COLEQADB, user: NimsMonitor, winauth: 0, encrpytion: 0, timeout: 300
Mar 12 18:43:52:058 [13756] sqlserver: testClient starting with: user: NimsMonitor, conn: COLEQADB
Mar 12 18:43:52:058 [13756] sqlserver: Profile: test connection profile, data engine connecting to database COLEQADB, using connection test connection, user: NimsMonitor, winauth: 0, encr: 0, tls_enable: 0
Mar 12 18:43:52:058 [13756] sqlserver: (CreateConnString) Starting for profile - test connection profile
Mar 12 18:43:52:058 [13756] sqlserver: ptConn->ntauth=0, [0][][COLEQADB][(null)]
Mar 12 18:43:52:058 [13756] sqlserver: (CreateConnString) Provider=MSDASQL;Driver={SQL Server};Server=COLEQADB;Database=master;UID=NimsMonitor;PWD=*****;Encrypt=no;MultipleActiveResultSets=yes;
Mar 12 18:43:52:058 [13756] 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][Shared Memory]SSL Security error
Mar 12 18:44:48:998 [13384] sqlserver: Profile: COLEQADB, connect retry 2

Environment

Release : 20.1

Component : UIM - SQLSERVER

Resolution

The customer enabled the TLS 1.2 at the SQLServer and disabled SSL 2.0, 3.0, PCT 1.0/ TLS 1.0, 1.1, RC4 and DES

After enable the TLS at the probe, the connection worked