Forum Discussion
fabricpribeiro
Post Patron
Post PatronFabric - 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...
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
Community Support
Community SupportHi fabricpribeiro ,
We haven’t received any update from your side. Please let us know if you need any additional details or clarification.
Thank you.