After connecting for mirroring, I only see undefined

[EwoutVisionBI]

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.

[EwoutVisionBI · Accepted solution]

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

[EwoutVisionBI]

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.

[EwoutVisionBI]

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

[Anonymous]

Hi, @EwoutVisionBI 

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

Tutorial: Configure Microsoft Fabric mirrored databases from Azure SQL Database (Preview) - Microsof...

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

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.