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 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you rohit1991 for the prompt response.

Since your Managed Private Endpoint (MPE) shows Approved/Succeeded, the likely issue is DNS resolution. Ensure your SQL server has an A record in the Private DNS Zone( "privatelink.database.windows.net") pointing to the private IP of the MPE. Also, link the VNet hosting Fabric to this DNS zone. Test resolution from a VM in the same VNet using nslookup <your-sql-server>.database.windows.net-it should return the private IP. Confirm SQL Public Network Access = Disabled and the private endpoint shows Approved. Once DNS resolves correctly, retry the mirrored database connection via the Service Principal.

flatproject's avatar
flatproject
Regular Visitor
10 months ago

Hi v-venuppu and thanks for getting back to me.

My SQL server has an A record in the Private DNS Zone pointing to a private endpoint for keeping the traffic inside our vnet but not pointing also at the MPE. How can i find the private IP of the MPE to add it to the Recordset under "privatelink.database.windows.net"? If i go to the SQL Server, Networking, Private Access and click on the MPE created by Fabric i get a 401 error which i believe is expected because the MPE is managed by Azure. Also, if i go to the NEtwork Foundation and check all Private Endpoints, Pending Connections, Private Link Services I cant find the name of the MPE.

 

Any help much appreciated.

 

Thanks