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...
To successfully configure Mirroring for Azure SQL Database, the principal used to connect to the source Azure SQL Database must be granted the permission ALTER ANY EXTERNAL MIRROR, which is included in higher level permission like CONTROL permission or the db_owner role.
You can refer to the folllwing link to know more about it.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.