Forum Discussion

CoulterJames2's avatar
CoulterJames2
Advocate II
6 months ago
Solved

Recommended 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 ...
data engineering
  • deborshi_nag's avatar
    deborshi_nag
    6 months ago

    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. 

     

Anonymous's avatar
Anonymous
Not applicable
6 months ago

Hi CoulterJames2,

 

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to deborshi_nag  for prompt and helpful responses.

Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

 

Best regards,
Prasanna Kumar