Forum Discussion
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 ...
Hey tayloramy, appreciate the response. Indeed it looks like an on-premises data gateway is required but the gateway software requires Windows server 2019 whereas the on prem database is hosted on Windows server 2016 unfortunately so that isn't an option.
You're right that I need this gateway to sit behind my on prem network's firewall. I have set up a site to site VPN between the Azure VNET to the on prem network and so if I can get the Fabric traffic going through the azure VNET, then it is effectively behind the on prem network's firewall and can access the on prem SQL server.
Hopefully the Azure team will be able to add this functionality too as it seems like a pretty common use case.