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...
This is indeed a known limitation in Microsoft Fabric. Currently, only the creator/owner of the mirrored database can change the configuration, and other users, including workspace admins, are unable to make changes due to permission restrictions.
To address this, Microsoft has introduced a feature allowing users with the right permissions (e.g., workspace admins) to take ownership of Fabric items. However, this feature is not yet supported for mirrored database items.
Please check below blogs for reference.
https://learn.microsoft.com/en-us/fabric/fundamentals/item-ownership-take-over