Does the UIM data_engine probe support MultiSubnetFailover
Article ID: 216313
Updated On:
Products
Issue/Introduction
We are using a multi cluster database and our DBA told us to add MutliSubnetFailover=True to the data_engine parameters.
May 24 09:19:37:317 [5544] 1 de: DB Version: [Microsoft SQL Server 2017 (RTM-CU23) (KB5000685) - 14.0.3381.3 (X64) Feb 9 2021 12:08:50 Copyright (C) 2017 Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: )]
Environment
Release : 20.3
Component : UIM - DATA_ENGINE
data_engine 20.31
Resolution
The data_engine as of version 20.31 does not support MultiSubnetFailover and data_engine parameter should be set to false.
MultiSubnetFailover=False
Data_engine probe 20.31 and earlier versions use OLE DB driver for MS SQL and hence does not support multisubnet failover for Always On replicas, according to AlwaysOn Multi-Subnet Failover and SSIS and OLE DB Connection Manager
Additional Information
Attachments
Feedback
