Operational Defect Database
BugZero found this defect 186 days ago.
Data sources
All data on this page is proprietary to BugZero® or gathered from public sources
Microsoft SQL Server | 2698036
The Log Reader Agent creates a dynamic linked server for the listener to verify the metadata when you configure a transactional publication on an Always On availability group (AG). This dynamic linked server is temporary and dropped after the verification. When the AG is deployed with replicas in different subnets, this dynamic linked server connection might time out as it tries to connect serially. After applying the fix, if the Log Reader Agent is configured to use the MultiSubnetFailover parameter as 1, the dynamic linked server is also created with the MultiSubnetFailover parameter as 1, which allows connection to occur in parallel.
Last update date:
11/16/2023
Affected products:
SQL Server 2022 on Linux
SQL Server 2022 on Windows
Affected releases:
build lower than 16.0.4095.4
Fixed releases:
16.0.4095.4
Description:
The Log Reader Agent creates a dynamic linked server for the listener to verify the metadata when you configure a transactional publication on an Always On availability group (AG). This dynamic linked server is temporary and dropped after the verification. When the AG is deployed with replicas in different subnets, this dynamic linked server connection might time out as it tries to connect serially. After applying the fix, if the Log Reader Agent is configured to use the MultiSubnetFailover parameter as 1, the dynamic linked server is also created with the MultiSubnetFailover parameter as 1, which allows connection to occur in parallel.
