Forum Discussion
Azure SQL mirroring
When mirroring is set up on Fabric only the creator/owner of the mirror can change the configuration. Other users, even workspace admins, are shown an error message: " Failed to get source connection...
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!