This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(272, 64%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHH%3C/text%3E%3C/svg%3E)
When I attempt to perform the 'Export Data-tier Application' task on an Azure SQL DB on one of our Managed Instances, I receive this error after about a minute or two of extracting and validating processes:
*** Error exporting database:One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71501: Error validating element <unnamed>: Role Membership: <unnamed> has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element <unnamed>: Role Membership: <unnamed> has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element <unnamed>: Role Membership: <unnamed> has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element <unnamed>: Role Membership: <unnamed> has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element <unnamed>: Role Membership: <unnamed> has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object [AzureGroup].
Error SQL71501: Error validating element Permission: Permission has an unresolved reference to object [AzureGroup].
We had recently configured our SQL Managed Instance to allow Azure Active Directory authentication via Groups. This doc was used for guidance on how to implement the configuration: https://learn.microsoft.com/en-us/azure/azure-sql/managed-instance/aad-security-configure-tutorial
Any help would be greatly appreciated, thanks!
An Azure relational database service.
A cloud-based identity and access management service for securing user authentication and resource access
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
@xiongNWN-8368
Please convey if you have used the Azure Data Sync on the DB that you are exporting. We have seen these error as documented here.
If not please convey so that we can check further regarding this.
Thanks
Navtej S
Hello Navtej,
I had previously attempted to follow the article you shared and have always come to an error while trying to perform an assessment within the DMA. The error I receive is similar to this article's: https://learn.microsoft.com/en-us/answers/questions/97756/fail-upload-dma-to-azure-sql.html
I have not been able to successfully perform the DMA. This was attempted with my local SSMS v18.7.1 and on the VM that houses the managed instance.
Thank you for your help!
Best,
~John
@xiongNWN-8368
I did check the issue you referred but the error is different for you and on the case you referred. For getting more information about this error, we would advise you to try other methods to export and check if you are able to do so. Check this document for different methods.
At this time we will also need access to your resources to troubleshoot further which is not possible here. We will ask you to raise ticket with our support and take this further. Share the ticket number with us so we can get traction on the same.
Please let us know if you have any further feedback or question.
Thanks
Navtej S
@xiongNWN-8368 - Please let us know if you have any further question.
Regards
Navtej S