There are two forms of JDBC URL for connecting to MSQSQL
1. Using hotname+port
2. Using hostname/instancename (Dynamic Port)
Option 2 is used to support scenarios where the port number may change (in this prospects case, SQL Server runs as a 6 node failover cluster running 12 instances).
Debezium does not support option 2:
Line 64 from here: https://github.com/debezium/debezium/blob/master/debezium-connector-sqlserver/src/main/java/io/debezium/connector/sqlserver/SqlServerConnection.java
Could SQL Server connector support hostname/instancename (Dynamic Port)?