How to fix "Microsoft SQL Error SQL71564: Error validating element [USERNAME]: The element [USERNAME] has been orphaned from its login and cannot be deployed."
I needed to export a database in BACPAC format today in order to restore it somewhere else, and I encountered the following error.
To resolve this issue, I deleted all of the users mentioned in the error log. After successfully creating the BACPAC file, I used it to create a new database with no problems.
Error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
One or more unsupported elements were found in the schema used as part of a data package.
Error SQL71564: Error validating element [USER1]: The element [USER1] has been orphaned from its login and cannot be deployed.
Error SQL71564: Error validating element [USER2]: The element [USER2] has been orphaned from its login and cannot be deployed.
Error SQL71564: Error validating element [USER3]: The element [USER3] has been orphaned from its login and cannot be deployed.
Error SQL71564: Error validating element [USER4]: The element [USER4] has been orphaned from its login and cannot be deployed.
Error SQL71627: The element User: [IIS APPPOOL\USER5] has property AuthenticationType set to a value that is not supported in Microsoft Azure SQL Database v12.
(Microsoft.SqlServer.Dac)
------------------------------
BUTTONS:
OK
------------------------------
Comments
Post a Comment