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 can’t directly see the Managed Private Endpoint (MPE) IP - it’s managed internally by Fabric, so the 401 error is expected.
Instead, confirm that your Private DNS Zone has an A record for your SQL server pointing to its private endpoint IP.Then, link this DNS zone to the Fabric managed VNet (shown under Virtual network links).You don’t need to add the MPE IP manually - Fabric resolves it automatically once the DNS zone is linked.Finally, validate with nslookup <your-sql-server>.database.windows.net from a VM in the same VNet; if it returns a private IP, retry the Fabric mirror setup - it should now connect privately.

Thank you.

  • flatproject's avatar
    flatproject
    Regular Visitor
    10 months ago

    Hi v-venuppu ,

     

    I have confirmed that my Private DNS Zone has an A record for the SQL server pointing to its private endpoint IP. Under Virtual Network Links (in the Private DNS ), there is a link created but i'm not sure if its related to fabric.

    If i click edit this is how it looks:

     

    If i try to add a new Virtual Network Link, i dont get an option under Virtual Network to select the Fabric managed vnet.

     

    Should i be able to see the Fabric VNET in the dropdown?

     

     

     

    Thanks,