topic Re: Azure SQL mirroring in SQL database

Azure SQL mirroring

AugustoChaves — Fri, 03 Jan 2025 20:40:49 GMT

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. Please check if the source connection exists and you have the permission".

Questions:
1) Is there a way to change the "owner"?

2) Is this by design? What if the owner/creator leaves the company?

Re: Azure SQL mirroring

Anonymous — Mon, 06 Jan 2025 07:25:26 GMT

Hi AugustoChaves

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.

https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-limitations#permissions-in-the-source-database

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.

Re: Azure SQL mirroring

AugustoChaves — Mon, 06 Jan 2025 15:23:55 GMT

The credential I'm using is already DBO / owner on that database. Shouldn't that be enough?

Re: Azure SQL mirroring

idrismotiwala — Tue, 07 Jan 2025 19:20:59 GMT

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!

Re: Azure SQL mirroring

AugustoChaves — Wed, 08 Jan 2025 21:36:39 GMT

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?

Re: Azure SQL mirroring

idrismotiwala — Wed, 08 Jan 2025 21:43:54 GMT

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.

https://learn.microsoft.com/en-us/fabric/database/mirrored-database/azure-sql-database-troubleshoot#t-sql-queries-for-troubleshooting

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!

Re: Azure SQL mirroring

Anonymous — Thu, 06 Feb 2025 10:11:36 GMT

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