Error SQL71564 Extract Data-tier Application.

Applies to: SQL Server 2014 Enterprise Edition.
 

Problem Description.
 

I was using the Extract Data-tier Application Wizard of SQL Server Management Studio to create a DAC package from an specific database when I got the following error message from the wizard.

Validation of the schema model for data package failed.
Microsoft SQL Server Management Studio
Error SQL71564: Error validating element [paul]: The element [paul] has been orphaned from its login and cannot be deployed.
Error SQL71564: Error validating element [paul]: The element [paul] has been orphaned from its login and cannot be deployed.
(Microsoft.SqlServer.Dac)

Solution
 

The solution in our scenario was to manually delete the two orphaned database users "paul" and "mmartinez" from the security folder that belongs to the database, since their associated SQL Server logins no longer exist on the instance. You can also use the script offered on the following article to delete orphaned users:

Script to Find and Drop All Orphaned Users in All SQL Server Databases.


If you prefer to resolve or fix those orphaned users, you can use the following article.


Troubleshoot Orphaned Users (SQL Server).



 

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.