Forum Discussion
Azure SQL mirroring
AugustoChaves , there are 2 aspects of Mirror creation and connection.
1) The Mirrored Item that is created in Fabric workspace. The workspace ownwer/admin can provide access to other users in the Workspace Manage permissions settings. This should allow other users to manage the Mirror item
2) The credentials to connect to the database that performs the Mirroring or data replication. What you and Yolo mentioned above is correct. Currently, the user needs to have dbo/CONTROL database permissions.
Hope this helps!
Thanks Idris. The user in question is already a workspace admin and has db_owner level access at the Azure SQL database. Any other ideas of what I could try or investigate?
AugustoChaves, could you try running the queries below to see if Mirroring is running behind the scenes for the Azure SQL database? I'd recommend logging in SQL Server using the dbo creds.
If Mirroring is looking good, I'd create a support ticket from Fabric on the behavior and have our support engg team investigate on why the user is unable to open the Mirror.
Hope this helps!