UIM 23.4.x Upgrade fails with "Login failed for user..."

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

UIM 23.4.x upgrade fails with the error "Login failed for user..." when using MS SQL Server as the backend database.

Additional setup information:
* The data_engine probe User ID is configured with a domain user (Windows Authentication mode).
* The Nimsoft Robot Watcher service "Log on as" is configured with the same user ID as the data_engine probe.

Error in the uimserver_ia_install.log

com.microsoft.sqlserver.jdbc.SQLServerException: Login failed for user 'Windows\domain user'

Environment

Any DX UIM 23.4 Cumulative Update

Resolution

Logged in with the domain user configured in the data_engine probe and relaunch the UIM installer.

Additional Information

UIM Microsoft SQL Server Requirements for Windows Authentication