topic Re: After connecting for mirroring, I only see undefined in Mirroring

After connecting for mirroring, I only see undefined

EwoutVisionBI — Wed, 23 Oct 2024 11:28:10 GMT

With a new SQL Server on vCore and open to the public network, I get this error after connecting:

I tried with a System Assigned Managed Identity and a User Assigned Managed Identity with Fabric API read/write permissions. Both did not work. SQL admin user or my Entra ID user (owner of database) did not make a difference either.

Can anyone help out? I'm hoping to make a simple guide and/or demo to show how mirroring can be used.

I found some tutorials online, but they don't describe all the necessary steps, most describe only the steps after seeing the mirror tables.

Re: After connecting for mirroring, I only see undefined

Anonymous — Thu, 24 Oct 2024 02:47:19 GMT

Hi, EwoutVisionBI

Please check out the following links hopefully it will help you.

Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsoft Fabric | Microsoft Learn

Troubleshoot Fabric mirrored databases from Azure SQL Database (Preview) - Microsoft Fabric | Microsoft Learn

Best Regards,

Community Support Team _Charlotte

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

Re: After connecting for mirroring, I only see undefined

EwoutVisionBI — Thu, 24 Oct 2024 06:32:23 GMT

Thank you Zhang Tin, I read both of those pages before, but configuring them did not change the error.

Re: After connecting for mirroring, I only see undefined

EwoutVisionBI — Thu, 24 Oct 2024 06:49:35 GMT

I think I got one step further, before I tried making it in a workspace with Fabric capacity paused. I mean I know it's a Fabric resource, but I heard it's free so I was hoping it's not required to be on.

I now tested it with a new workspace that does have F2 capacity on, and my error is clearer:

I will change my configuration back to only system assigned (per the docs) and let our esteemed Fabric forum readers know the results.

Re: After connecting for mirroring, I only see undefined

EwoutVisionBI — Thu, 24 Oct 2024 07:35:54 GMT

Yes, it turns out the Fabric capacity had to be on for this feature.