Forum Discussion

flatproject's avatar
flatproject
Regular Visitor
10 months ago

SQL Mirroring - Managed Private Endpoint

I have a UKWest Azure SQL database in a vnet/subnet using a private link with public network access disabled. I have created a trial capacity on Fabric so I can test the SQL mirroring and start usin...
workspaces
v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
10 months ago

Hi flatproject ,

You don’t need to manually link Fabric’s Managed VNet to your Private DNS Zone - it’s Microsoft-managed and doesn’t appear in Azure’s VNet list.Just ensure your Private DNS Zone is correctly linked to the VNet hosting your SQL Private Endpoint, and that the A record points to the SQL’s private IP.If nslookup <your-sql-server>.database.windows.net from that VNet resolves to the private IP, Fabric will connect automatically. In short, correct DNS linkage inside Azure ensures Fabric’s MPE connects - no Fabric-side DNS link required.

Thank you.

  • flatproject's avatar
    flatproject
    Regular Visitor
    10 months ago

    Hi v-venuppu,

     

    The private DNS zone is correctly linked to the VNET hosting the SQL Private Endpoint and the A record points to the SQL's private IP. This is production system, its all LIVE so im quite sure all is working. 

     

     

    Anything else that i can try?

     

    Thank you