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 database being mirrored. It has these permissions: ALTER ANY EXTERNAL MIRROR, CONNECT, SELECT, VIEW PERFORMANCE DEFINITION
- The Connection is created to use the principal for authentication but also created by the principal, so it is the owner.
- The mirror is created by the principal also and uses the connection.
- The principal has admin level access on the workspace
When I view the mirror on the workspace and choose "Start replication" it then switches to running. However the tables never replicate. If I then choose to "Configure Replication" I get a permissions error as the connection is owned by the service principal.
If I run `EXEC sp_help_change_feed;` on the source database, I can see everything is at State 1 (pending) while a manually setup (not using the API) mirror on another workspace generates state 4 results.
There is the issue that we cannot see the connection or configure replication as its owned by the principal. I am not sure if we can set that as shared using the API? But the main issue is the tables are not replicating even though the mirror shows as running.
Has anyone seen these issues?
