Forum Discussion
Solved
Replication Issue With Azure SQL Mirror - With Service Principal Owner
I have setup an Azure SQL mirror in a workspace using a service principal and the fabric REST API. Service Principal in an Entra group, the group has a login on the server and a user on the data...
For anyone reading this in the future, when the mirror is created by the API, you need to set the SAMI permissions either by going to the mirror in the portal and choosing share or by using an API call. I had not done that.
For anyone reading this in the future, when the mirror is created by the API, you need to set the SAMI permissions either by going to the mirror in the portal and choosing share or by using an API call. I had not done that.