question

ElioPanting-4835 avatar image
0 Votes"
ElioPanting-4835 asked Mike-Ubezzi commented

Across region SQL MI connectivity

I was looking into the network connectivity for SQL MIS and want to confirm if is plausible to connect to SQL Mi from a different region from where is deployed peering or global peering and I found that now is allows based on a announcement made on 9/22, now my question, can a MI created before that date, can be reconfigured or converted to allow global peering?

azure-sql-database
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi, @ElioPanting-4835. I have updated the answer initially provided with feedback I received from the product group. As noted, there is no official path to upgrade existing deployments but since MI is a large ARM deployment and by resizing your instance, with the new VNET creation, the desired global VNET peering functionality becomes available....by default. Please let me know if you have any additional questions. Regards, Mike.

Additional Information: Overview of Azure SQL Managed Instance resource limits (link)


0 Votes 0 ·

1 Answer

Mike-Ubezzi avatar image
0 Votes"
Mike-Ubezzi answered Mike-Ubezzi edited

Hi, @ElioPanting-4835 - Yes, as long as the VNET was created using Azure Resource Manager (ARM), which is the case with Managed Instance. Please see requirements and constraints for specifics, as there are quite a few. One stands out:

  • The virtual networks you peer must have non-overlapping IP address spaces.

Additional Information:

Answer Update:

At this time we are not supporting upgrades of existing MIs to global VNET peering. Note: One way to "trick" this is if the customer has Gen4 and by upgrading to Gen5 they will be moved to a new tenant ring (virtual cluster) and therefore upgraded with their setup and would get the VNET peering.






· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @Mike-Ubezzi-MSFT for getting back on this. I do have a SQL MI deployed in a vNet (West EU) peered to a vNet (East US), I can access other resources from East US but not the SQL MI, all resources deployed with ARM and yes, no overlapping IP and all other restrictions.

The SQL MI was deployed at the beginning of the year. Reading the document you sent, on 9/22 accessing SQL MIs on Global peering was enabled, my question, those that applies to MIs created before that date?

0 Votes 0 ·

I am confirming what the options are for existing MI deployments. Thanks for the additional detail, @ElioPanting-4835. Regards, Mike.

0 Votes 0 ·