Backend UIM database (MSSQL) moved, and unable to reconnect.

book

Article ID: 209681

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

The SQL database was moved  to a new server with Availability Group using a listener.

We are unable to get the UIM server to talk to the new server, the data_engine probe test button keeps timing out when activated.

 

Cause

This is an issue on the Microsoft database end

Environment

Release : 9.0.2

Component : UIM - INSTALL

Resolution

This is a solution on the Microsoft sql database application:

Changed the SQL provider from SQLOLDEDB to SQLNCLI11

https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/always-on-client-connectivity-sql-server?view=sql-server-2017