I have created two sql managed instances which has same ip address, i need to peer two vnets which was having same ip adress, how to peer both vnets and create failovergroup for both sql MI.

Question

I have created two sql managed instances which has same ip address, i need to peer two vnets which was having same ip adress, how to peer both vnets and create failovergroup for both sql MI.

Answer 1

[@Saiteja Inabathina ]Since you've created two SQL managed instances with the same IP address and need to peer two VNets that share this IP address, the process involves addressing the IP conflict first. You'll need to reconfigure the IP addresses to be unique within each VNet. Once done, you can proceed to peer the VNets and create a failover group for both SQL managed instances, ensuring smooth functionality without IP conflicts.

Source: Stackoverflow

Answer 2

Hi, @Saiteja Indukuri If two vnets that host two MIs have overlapping IP address range, vnet peering setup is not possible. 

 So you would need to create another vnet/subnet with non-overlapping IP address range.

 Creating auto-failover group is done by creating the second Azure SQL Managed Instance as secondary instance in failover group (so this is configured during the setup process and is supported in Azure Portal). https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/failover-group-add-instance-tutorial?view=azuresql&tabs=azure-portal

 We have demo/tutorial covering this topic: https://www.youtube.com/watch?v=xAi8Ltd0N1E

Another useful resource is: https://www.youtube.com/watch?v=Mm5olRl7kS0

I hope this information helps.

Regards

Geetha