Forum Discussion
Azure SQL mirroring to Fabric fails with Error occured while interacting with landing zone
Update to this,
I found a reddit post with the same issue,
https://www.reddit.com/r/MicrosoftFabric/comments/1o696yw/the_issue_of_creating_mirrored_databases_using/
Its pointed out that the SAMI needs permission on the mirrored database item.Also when reading the fine prints in the documentation its stated there as well.
So its really down to me not grasping the details.
Once I added the SAMI to the mirroring object, API works fine for setting up the mirroring.
Thanks spaceman127 for your time
Update to this,
I found a reddit post with the same issue,
https://www.reddit.com/r/MicrosoftFabric/comments/1o696yw/the_issue_of_creating_mirrored_databases_using/
Its pointed out that the SAMI needs permission on the mirrored database item.
Also when reading the fine prints in the documentation its stated there as well.
So its really down to me not grasping the details.
Once I added the SAMI to the mirroring object, API works fine for setting up the mirroring.
Thanks spaceman127 for your time
Super UserHi lobitconsulting ,
Great!
I tested it tonight because the problem kept bothering me, and I encountered exactly what you described.
The permission was missing.
I was able to reproduce it.
Perfect, your problem is solved.
And I'm happy to help when I can.
And feel free to mark the solution and leave some kudos.
Best regards