Forum Discussion
Bug in Fabric API SDK - Creating Azure SQL Mirror Database
JAnder Assuming the Service Principal is part of the security groups which the admin switch is enabled for them I don't have any other ideas for configurations that might be missing.
I did see issues in the past where Fabric didn't resolve correctly security groups memberships for users, especially service principals.
I don't know if a trial license doesn't require the admin switch to be enabled for creating items.
I would suggest (if possible) to temporarily enable the "Users can create fabric items" setting for the entire organization and try to see if the issue is indeed related to that setting. Note that you might have to wait some time for the change to take affect.
JAnder I suggest you make sure that the admin switch for creating items is enabled in Fabric's admin portal.
The item type you are trying to create is a GA item, so there's an admin switch that controls whether Fabric GA items can be created by users in the tenant.
There's also a possibility for capacity admins to override the tenant level configuration for a specific capacity,so you can check there as well.
Reference: Enable Microsoft Fabric for your organization - Microsoft Fabric | Microsoft Learn
Thanks for the reply Amos. Under Tenant Settings and "Users can create fabric items" we have a security group which includes the service principal used when creating the mirror. In the fabric capacity settings, under "delegated tenant settings", we do not have any of the overrides in use.
Are there any specific settings that might impact this working. With it working on a trial licence that would indicate an issue with the setup I agree.
JAnder Assuming the Service Principal is part of the security groups which the admin switch is enabled for them I don't have any other ideas for configurations that might be missing.
I did see issues in the past where Fabric didn't resolve correctly security groups memberships for users, especially service principals.
I don't know if a trial license doesn't require the admin switch to be enabled for creating items.
I would suggest (if possible) to temporarily enable the "Users can create fabric items" setting for the entire organization and try to see if the issue is indeed related to that setting. Note that you might have to wait some time for the change to take affect.
Thanks again Amos, it looks like it may have been a replication problem. I switched to full organisation can create items and it worked, but then I switched back to the groups and it worked again!
Thanks very much for your help.