Fail to integrate UIM (Windows) with external cabi (Linux)

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The integration with a JasperServer 7.1.1.1 (Linux) seems to have finished ok, but any report or even running the dashboard return next error:

The TCP/IP connection to the host <DB_SERVER_NAME>, port <DB_SERVER_PORT> has failed. Error: "<DB_SERVER_NAME>. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that the TCP connections to the port are not blocked by a firewall."

UIM Server and OC are both installed on Windows, with MS SQL as database backend, and Windows Authentication is being used instead of MS SQL Server authentication.

Environment

Release : 20.3

Component : UIM - CABI

Cause

As per product documentation:

(Microsoft SQL Server Windows Authentication Only) If you are using Microsoft SQL Server Windows Authentication, the CABI Server system, cabi_external probe robot, and Operator Console (OC) robot must have Windows operating systems. No requirements exist for matching operating systems if you are NOT using Microsoft SQL Server Windows Authentication.

Resolution

To make the integration works, in this particular scenario, the MS SQL Authentication needs to be configured to use MS SQL account instead of Windows Authentication.

1. Change the Nimsoft Robot Watcher to use System Account.

2. Change the data_engine Database settings to use a MS SQL account, and make sure the IntegratedSecurity=true is removed from the connection string

3. Restart the Nimsoft Robot Watcher service.

 

Additional Information

Install or Upgrade for an External CA Business Intelligence JasperReports Server