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 ,

Your DNS setup looks correct - the nslookup output confirms resolution via the private IP.
Next, ensure your Fabric workspace and SQL Server are in the same region (UK West), as Managed Private Endpoints don’t work cross-region.If regions match, delete and recreate the MPE in Fabric, then wait until its status is Approved and Succeeded.Retry creating the mirrored connection using the same Service Principal with required roles (##MS_ServerStateReader##, SELECT, ALTER ANY EXTERNAL MIRROR).If it still fails, clear the DNS cache in Fabric (recreate the connection after 15 min).These steps usually fix the connection denied / still using public route issue once DNS and permissions are already correct.

Thank you.

  • flatproject's avatar
    flatproject
    Regular Visitor
    10 months ago

    Hi v-venuppu ,

    I tried deleting and recreating the MPE and the mirrored connection a few times but im still getting the same error message 

    An exception occurred: DataSource.Error: Microsoft SQL: Reason: An instance-specific error occurred while establishing a connection to SQL Server. Connection was denied because Deny Public Network Access is set to Yes. For more information, see https://go.microsoft.com/fwlink/?linkid=2323206.

     

    Anything else I can try?

     

     

    Thank you for the continuous support