Forum Discussion
Super UserMirroring in fabric
I'm trying to test mirroring feature in Microsoft fabric, I have database on azure sql database and i'm trying to mirror it to fabric warehouse, on setting up the connection I'm getting below error
The database cannot be mirrored to Fabric due to below error: User does not have permission to mirror the database.
What are the permission required for it and where to set it up
Hi. There might be some configurations you might be missing, like enabling manage identities. Please check this docs that shows exactly each configuration you need to make it work:
I hope that helps,
2 Replies
- ibarrau
Hi. There might be some configurations you might be missing, like enabling manage identities. Please check this docs that shows exactly each configuration you need to make it work:
I hope that helps,
- NickA01
Resolver III
I've been trying to do this using an Azure Service Principle this morning.
A couple of failures but once I adjusted the Db I wanted to mirror to use the appiropriate compute, got it working.
The issues I had were on the source db side.
Here's my script --> Hope it helps someone./**********************************************************************
* Steps to mirror a DB into Fabric using an Azure Service Principle *
*
*
* create LOGIN [ <ServicePrincipleName> ] FROM EXTERNAL PROVIDER;
*
* ALTER SERVER ROLE [##MS_ServerStateReader##] ADD MEMBER [<ServicePrincipleName>];
*--------------------------------------------------------------------------------------
*
* Now switch to the db to be mirrored
*
* CREATE USER [<ServicePrincipleName>] FOR LOGIN [<ServicePrincipleName>];
* GRANT CONTROL TO [<ServicePrincipleName>];
*
**************************************************************************/
The Nick
If the post helps please give a thumbs up || If it solves your issue, please accept it as the solution to help the other members find it more quickly.
If it's the biggest heap of stinky smelly stuff then I'm sorry .
