oi_connector does not start: not able to communicate with the DB Server. SQLServerException

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We have deployed oi_connector on a dedicated robot attached to the primary hub and have configured the data_engine_address to point to the primary hub. 

The probe fails to start and it logs: 

Jan 05 09:52:35:933 [main, oi_connector] com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user '<user>\<domain>'. ClientConnectionId:################################
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
    at com.microsoft.sqlserver.jdbc.TDSTokenHandler.onEOF(tdsparser.java:256)
    at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:108)
   [...]
    at com.nimsoft.probe.gateway.oi_connector.jdbc.DBConnectionPool.create(DBConnectionPool.java:87)
    at com.nimsoft.probe.gateway.oi_connector.jdbc.DBConnectionPool.create(DBConnectionPool.java:18)
    at com.nimsoft.probe.gateway.oi_connector.AbstractObjectPool.intializePool(AbstractObjectPool.java:70)
    at com.nimsoft.probe.gateway.oi_connector.jdbc.DBConnectionPool.initializePool(DBConnectionPool.java:45)
    at com.nimsoft.probe.gateway.oi_connector.OIConnectorProbe.doStart(OIConnectorProbe.java:76)
    at com.nimsoft.probe.gateway.oi_connector.OIConnectorProbe.main(OIConnectorProbe.java:52)

Jan  5 09:52:36:043 [2248] Controller: Max. restarts reached for probe 'oi_connector' (command = <startup java>)

In the Data_engine we are using Windows Authentication 

Environment

UIM 20.4.x

oi_connector 1.52

Cause

Network and User Permission

Resolution

•  Ensure that firewall access from OI Connector robot machine to port 1433 is enabled.

•  Ensure that the Nimsoft Robot Watcher service on oi_connector robot is set to run with the same domain user account that is running the in the Primary Hub and OC Robots. 

 

The JDBC connection should be successful after this change.