Forum Discussion

waltheed's avatar
waltheed
Impactful Individual
2 years ago

Mirroring Azure SQL database in Fabric

I ran into 2 issues follwing these instructions: Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsoft Fabric | Microsoft Learn 1. connecting using...
Need Help
Martin_inndx's avatar
Martin_inndx
Regular Visitor
2 years ago

I was able to folow the tutorial, but if I look in the SQL database and run this command:

SELECT * FROM sys.dm_change_feed_errors;

I see a lot of entries where error_message = "Error occurred while interacting with landing zone."

Does anyone know what it means?

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Martin_inndx ,

Have submitted this issue internal to confirm, would update here as soon as possible if there is any update about it.

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Martin_inndx's avatar
    Martin_inndx
    Regular Visitor
    2 years ago

    Hi Anonymous 

    I actually got it working. I did not give the Managed Identity access to the Fabric Workspace.

    One other thing that I don't understand is why each table that get's mirrored, have "dbo_" appended infront of the table names. I suppose I need to create a new topic for that.

    • Suerima's avatar
      Suerima
      Frequent Visitor
      1 year ago

      I keep encountering the error message: 'Error occurred while interacting with the landing zone,' even though I have granted Managed Identity access to the Fabric Workspace.