Can no longer login from the Admin or Operator Console post upgrade

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)
• CA Unified Infrastructure Management On-Premise (Nimsoft / UIM)
• CA Unified Infrastructure Management SaaS (Nimsoft / UIM)

Issue/Introduction

data_engine connection test displayed the error:

The login is from an untrusted domain and cannot be used with Integrated authentication, e.g., 

Contacting data_engine probe...Executed async test_connection on /XXXXXX/XXXXXXXXX/xxxxxxxxx/data_engine, please wait...Waiting...test connection DONE - result: Connected: noPing: noDB Version: n/adata_engine schema version: n/aCOM Error [0x80004005] Unspecified error - [Microsoft OLE DB Driver for SQL Server] Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.(1)

Environment

• DX UIM 23.4 CU5
• data_engine
• Admin Console
• Operator Console

Cause

• password issue

Resolution

Via the IM, the data_engine probe contained an error upon test of the connection:

Contacting data_engine probe...Executed async test_connection on /XXXDEV/XXXXXXDEV/xxxxxxxxx/data_engine, please wait...Waiting...test connection DONE - result: Connected: noPing: noDB Version: n/adata_engine schema version: n/aCOM Error [0x80004005] Unspecified error - [Microsoft OLE DB Driver for SQL Server] Login failed. The login is from an untrusted domain and cannot be used with Integrated authentication.(1)

This error occurs when attempting to use Integrated Authentication (Windows Authentication) to connect to Microsoft SQL Server from a domain that SQL Server does not trust.

Windows auth setup seemed fine and nothing has changed expect perhaps the cross-domain trust.

 

It was working previously so advised customer to check with their database team as to what changed in the backend database which affected the ability to authenticate.

 

Once the customer updated the password in the data_engine it started to work again without error/issue.