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
  • flatproject's avatar
    flatproject
    Regular Visitor
    10 months ago

    Hi v-venuppu ,

     

    Thank you for your continuous support. I will raise a support ticket and update the thread here with hopefully a solution.

     

    Thanks you

    • flatproject's avatar
      flatproject
      Regular Visitor
      10 months ago

      Hi v-venuppu ,

       

      I have spoken to support and basically the documentation doesnt mention anywhere that in order for the Managed Private Endpoint and SQL mirroring to work you need to have

      1) Public Access enabled

      and also

      2) "Allow Azure services and resources to access this server" checked.

       

      Unfortunately this makes the product unusable for us.

       

       

      Thanks again for your help.

      • ThomasKwakman3's avatar
        ThomasKwakman3
        Regular Visitor
        6 months ago

        Hello flatproject,

        Just to be sure, here you are talking about configuration to be done at the SQL server side, correct?

        Thank you in advance for your answer 🙂