data_engine Test Connection fails with "Invalid connection string attribute" on MS SQL 2022

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When testing the database connection in the `data_engine` probe, the connection fails with the following error, even though logs may indicate that some operations (like OQS record inserts) are successful.

**Error Message:**(1) Open [Microsoft OLE DB Driver for SQL Server] Invalid connection string attributeCOM Error [0x80004005] Unspecified error - [Microsoft OLE DB Driver for SQL Server] Invalid connection string attribute

Environment

UIM Version: 23.4.x

Database: Microsoft SQL Server 2022

Database Configuration: Always On Availability Groups (AOAG) with Encryption enabled.

Driver: Microsoft OLE DB Driver for SQL Server (v18.x or higher).

Cause

The Microsoft OLE DB Driver for SQL Server (v18+) reports an "Invalid connection string attribute" when there is a conflict between the Integrated Security=SSPI parameter and the credentials (User ID/Password) provided in the standard data_engine configuration fields. 

Resolution

To fix this issue, clear the credentials and setting the connection parameters as follows:

1. Deactivate the data_engine probe in the Admin Console or Infrastructure Manager.

2. Open the data_engine configuration.

A. Delete any values in the User ID and Password fields so they’re completely blank.

B. Update the parameters: In Raw Configure, go to the setup section, find the parameters key, and set it to: Language=us_english;Integrated Security=SSPI;  
   (Make sure there are no other conflicting security attributes in the string).

3. Activate the data_engine probe back on.

4 Click Test Connection — it should now show “Connection successful.”