https://community.databricks.com/t5/data-engineering/foreign-catalog-sql-server-dynamic-port/m-p/62789#M32071 <P>When creating a Foreign Catalog SQL Server Connection, a port number is required. However, many sql servers have dynamic ports and the port number keeps changing. Is there a solution for this?</P><P>In most common cases, it should allow instance name instead of port number so sql servers can scan and use the correct port. But there is no option for that.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jim12321_0-1709756538967.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6527iACB97CC28F482307/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="jim12321_0-1709756538967.png" alt="jim12321_0-1709756538967.png" /></span></P><P>@foreign catalog&nbsp;</P> Wed, 06 Mar 2024 20:39:32 GMT jim12321 2024-03-06T20:39:32Z https://community.databricks.com/t5/data-engineering/foreign-catalog-sql-server-dynamic-port/m-p/62789#M32071 <P>When creating a Foreign Catalog SQL Server Connection, a port number is required. However, many sql servers have dynamic ports and the port number keeps changing. Is there a solution for this?</P><P>In most common cases, it should allow instance name instead of port number so sql servers can scan and use the correct port. But there is no option for that.</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jim12321_0-1709756538967.png" style="width: 400px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6527iACB97CC28F482307/image-size/medium/is-moderation-mode/true?v=v2&amp;px=400" role="button" title="jim12321_0-1709756538967.png" alt="jim12321_0-1709756538967.png" /></span></P><P>@foreign catalog&nbsp;</P> Wed, 06 Mar 2024 20:39:32 GMT https://community.databricks.com/t5/data-engineering/foreign-catalog-sql-server-dynamic-port/m-p/62789#M32071 jim12321 2024-03-06T20:39:32Z