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?
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.
@foreign catalog
