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
Super UserHi lobitconsulting,
I haven't tested it yet, but I think I've read somewhere that you have to specify the landing zone in the API call.
Here's an example. No guarantees, but you can give it a try.
Let us know if it works.
target": {
"type": "MountedRelationalDatabase",
"typeProperties": {
"defaultSchema": "dbo",
"format": "Delta",
"landingZone": {
"type": "Managed"
Best regards