[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

 Error SQL71564 Extract Data-tier Application
 

 

 

Home
Analysis Services
Azure
CLR Integration
High Availability
Open Source
Security
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
Tips
Troubleshooting
Tuning

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.