Export errors with Azure SQL DB

Question

Export errors with Azure SQL DB

hoover-hash123 6

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!

1 answer

Your answer

Answer 1

Navtej Singh Saini 4,226 Microsoft Employee Moderator

@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

hoover-hash123 6 Reputation points

2021-01-12T19:29:17.897+00:00

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
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-01-14T03:52:18.363+00:00

@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
Navtej Singh Saini 4,226 Reputation points Microsoft Employee Moderator

2021-01-19T02:16:32.737+00:00

@xiongNWN-8368 - Please let us know if you have any further question.

Regards
Navtej S

Share via

Export errors with Azure SQL DB

1 answer

Your answer