This article provides troubleshooting steps to address UMS connectivity issues with Microsoft SQL Server hosted on Azure infrastructure caused by the MultiSubnetFailover parameter setting.
Environment
The MultiSubnetFailover parameter is used for multiple clusters on multiple sub nets.
For more information, see the Client recovery latency during failover section in the SQL Server multi-subnet clustering article.
Problem
The MultiSubnetFailover parameter is not set to true.
Solution
→ Update to UMS version 12.12.100 or later. Starting from this version, MultiSubnetFailover=true is already applied by the driver, and no extra parameter is required in UMS.
If the issue persists, you can continue with the troubleshooting steps in Troubleshoot connectivity issues in SQL Server.