Hi,
At the end of scenario 2 there is this statement:
"Moreover, if you want outbound traffic from Azure SQL Managed Instance to originate from static IP addresses, you can associate a NAT gateway with the firewall to perform source NAT (SNAT). This is discussed in further detail in the documentation for firewall's public IP configuration."
However, at https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/connectivity-architecture-overview Networking Constraints, 8th bullet, I see "NAT gateway: Using Azure Virtual Network NAT to control outbound connectivity with a specific public IP address renders SQL Managed Instance unavailable." which appears to contradict the first statement.
Is there a supported way to ensure that Azure SQL MI has a specific source IP address when connecting outbound to Internet (e.g., to make a Linked Server connection)?
thanks!
Martin