Forum Discussion
Getting data/ mirroring from SQL Managed Instance to Fabrics
I'm pretty sure I used the gateway ip's for power bi and not servicefabric. Try that. ServiceFabric is not the same product as Fabric which is pretty confusing. I didn't remember there being an entry in the IP Gateway for only "Fabric".
you mentioned in your first comment that you didn't have "always up to date" turned on. That's a requirement for mirroring a managed instance. If you just want to use a copy activity you just just need to turn on the public endpoint and whitelist the ip gateways for Fabric for your region in the network security group setting...allowing traffic to port 3342 (which the public endpoint uses)
I whitelisted the ip with servicetag servicefabric. it still does not allow me to connect to azure managed instance
Hi subashmahat,
Thank you for confirming that you've whitelisted the IPs using the ServiceFabric service tag.
However, in some regions, using only the ServiceFabric tag may not be sufficient to establish a connection with Azure SQL Managed Instance.
We recommend verifying that port 3342 is open in your Network Security Group to allow inbound traffic for the public endpoint.
Also, please make sure that the public endpoint is enabled for your Azure SQL Managed Instance.
If the issue persists, you may need to manually whitelist the outbound IP ranges used by Microsoft Fabric for your region.
Helpful Reference:
Troubleshoot Common Connection Issues - Azure SQL & SQL database in Fabric | Microsoft Learn
Solved: Connecting to Azure SQL Database (Whitelisting IPs... - Microsoft Fabric Community
Solved: Re: Whitelisting of PowerBI IP address range in Fi... - Microsoft Fabric Community
— Yugandhar
Community Support Team.I'm pretty sure I used the gateway ip's for power bi and not servicefabric. Try that. ServiceFabric is not the same product as Fabric which is pretty confusing. I didn't remember there being an entry in the IP Gateway for only "Fabric".
I allowed the power bi ip addresses in the NSG, it had not worked. Then i found there were additional IP the NSG was still blocking. Once those were removed from the blocked list. I was able to connect to managed instance.
Mirroring will require me to change the update policy. Thank you for the help.
