data_engine inactive after change User ID to use a MS SQL account

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The data_engine doesn't start after changing the User ID. Microsoft Windows Authentication was used before to authenticate against MS SQL Server.

Now it is required to use a Microsoft SQL Server Authentication, but after make the changes, the data_engine fails to start.

Environment

Release : 20.3

Component : UIM - CABI

Cause

When using MS Windows Authentication, the integratedSecurity=true is added to the connection string. To start using MS SQL Server authentication, that parameter needs to be removed.

Resolution

Make sure to remove the integrated security parameter, save the changes, and restart the probe.

Additional Information

Install UIM Server

Install or Upgrade for a Bundled CA Business Intelligence JasperReports Server