Forum Discussion
CoulterJames2
Advocate II
Advocate IIRecommended Setup for SQL Server on Azure VM
I am working with a customer on a new Fabric setup. They have an F2 capacity and need to ingest data from a SQL Server database hosted on an Azure VM (not an Azure SQL Database). The connection from ...
Hello CoulterJames2
Since your customer's SQL Server is on a VM in it's own VNet, there is no private endpoint-native access, and Fabric capacity is <64 - you should use a Fabric Data Gateway.
Fabric On-Premises Data Gateway runs inside customer's VNet, and data flows through Microsoft backbone network - Data Factory Copy tasks should be able to reach it.
deborshi_nag
Super User
Super UserHello CoulterJames2
Since your customer's SQL Server is on a VM in it's own VNet, there is no private endpoint-native access, and Fabric capacity is <64 - you should use a Fabric Data Gateway.
Fabric On-Premises Data Gateway runs inside customer's VNet, and data flows through Microsoft backbone network - Data Factory Copy tasks should be able to reach it.