data engine probe not connecting to database server after migration to SQL Server 2019

Products

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

Issue/Introduction

The data engine probe is not connecting to the new database server after migration.

Environment

• Release: 20.3
• Database: MS SQL Server 2016->2019

Resolution

Post MS SQL Server DB migration from 2016 to 2019 the data_engine was not successfully connecting to the UIM database.

Cluster name was first used but cluster listener address was required.

The listener name is a special object to route traffic based on incoming query type.

See also:

https://dba.stackexchange.com/questions/146411/sql-availability-groups-can-clients-use-cluster-name-instead-of-listener-names 

Checked data_engine and hub settings which were correct and message throughput was excellent.