DX IM - UIM - sqlserver probe - not connecting - testing fail

book

Article ID: 210778

calendar_today

Updated On:

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