Forum Discussion

rd_123's avatar
rd_123
New Member
9 months ago

Fabric Mirrored SQL Server (on prem) does not support VNET data gateway

I would like to create a mirror for an on prem SQL Server database using a VNET data gateway for connectivity (as we have a S2S VPN set up) but this is not currently supported. When trying to create ...
Need Help
tayloramy's avatar
tayloramy
Super User
9 months ago

Hi rd_123,  

Today, mirroring an on-premises SQL Server in Fabric requires the on-premises data gateway (OPDG). The official “Mirrored SQL Server” docs and the security guide both call out OPDG explicitly for SQL Server sources, not the VNet data gateway. That’s why your VNet gateway doesn’t appear in the mirror wizard dropdown, even though it works for Dataflow Gen2. See: Mirrored SQL Server “behind firewall” notes and SQL Server mirroring security requirements (both updated Aug 22, 2025).

 

The reason for this is the gateway needs to exist behind your firewall, and a vNET gateway is sitting in Azure, not behind your firewall. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.