Forum Discussion
After connecting for mirroring, I only see undefined
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.
- Anonymous1 year ago
Yes, it turns out the Fabric capacity had to be on for this feature.
4 Replies
- AnonymousNot applicable
Yes, it turns out the Fabric capacity had to be on for this feature.
- AnonymousNot applicable
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.
- AnonymousNot applicable
Hi, Anonymous
Please check out the following links hopefully it will help you.
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.
- AnonymousNot applicable
Thank you Zhang Tin, I read both of those pages before, but configuring them did not change the error.