Forum Discussion

fabricpribeiro's avatar
fabricpribeiro
Post Patron
4 months ago
Solved

Fabric - Mirroring SQLServer MI - Permissions

Dears,   Can you please help me understand the permissions and identity I can use to do the mirrroing of SQLMI and Fabric?   1 - Can I use a workspace identity? or I need to use a service princip...
admin
security
  • V-yubandi-msft's avatar
    V-yubandi-msft
    4 months ago

    You need to set up the VNET Data Gateway in Azure, rather than on Windows. This gateway is an Azure resource that should be deployed within the same Virtual Network as your SQL Managed Instance. Its function is strictly for connectivity, so the service principal doesn’t require any permissions beyond those already assigned in Fabric  and SQL MI.

     

    Helpful Document: Microsoft Fabric Mirrored Databases From Azure SQL Managed Instance - Microsoft Fabric | Microsoft Learn

     

    I hope this clarifies the situation. If I’ve misunderstood any part of your situation, please let us know.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
3 months ago

Hi fabricpribeiro ,

We haven’t received any response as of now. Kindly take some time to review our response, and please let us know if any additional details or clarification are required from our side.

 

Thanks