The integration with a JasperServer 188.8.131.52 (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.
Release : 20.3
Component : UIM - CABI
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.
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.