Forum Discussion
Mirrored Azure SQL Database Won't Mirror
- Anonymous1 year ago
Hi mattke2b ,
If you have verified everything related to SAMI and is functioning as expected Please try the below steps nowDo not remove Azure SQL Database service principal name (SPN) contributor permissions on Fabric mirrored database item.
If you accidentally remove the SPN permission, Mirroring Azure SQL Database will not function as expected. No new data can be mirrored from the source database.
If you remove Azure SQL Database SPN permissions or permissions are not set up correctly, use the following steps.
- Add the SPN as a user by selecting the
...ellipses option on the mirrored database item. - Select the Manage Permissions option.
- Enter the name of the Azure SQL Database logical server name. Provide Read and Write permissions.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you - Add the SPN as a user by selecting the
Hi mattke2b
Ensure SAMI is enabled and set as the primary identity for the Azure SQL logical server
Remove all User-Assigned Managed Identities (UAMI) if present, as they override SAMI as the primary identity