OC logon fails with all users ; Error - Invalid Credentials

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

Deployed a new UIM 20.3 instance with MS SQL Server as the backend database
Data_engine -> Database -> User ID is set with an Active Directory service account (Windows Authentication)
UIM Server and OC installs were successful

Problem:
OC logon fails with all users including the default administrator user with error  'Invalid Credentials'

wasp.log error on OC robot

Unable to login from request: com.firehunter.ump.exceptions.DataFactoryException: Cannot create PoolableConnectionFactory (Login failed for user 'DomainName\OCRobotHostName$'

Environment

Release : 20.x

Component : UIM - OPERATOR CONSOLE

Cause

Requirements for Windows Authentication with Microsoft SQL Server are not set

Resolution

Configured the 'Nimsoft Robot Watcher' service 'Log On As' option on the OC robot with the same User Id configured on the data_engine probe

See Requirements for Windows Authentication in link below:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/20-3/installing/pre-installation-planning/install-and-configure-your-database-software/microsoft-sql-server.html#concept.dita_83d1dcc7b2f3d10a611ea4f413d4eef6b43374eb_RequirementsforWindowsAuthentication