When executing a SQL Packager executable, the program can fail with the error "The login already has an account under a different user name."

Cause

This happens because SQL Packager includes dependencies, and if there is a difference in a database role or a new database role is being created, it will attempt to create the user as part of the synchronization. This is why you may continue getting this error even after recreating the package with the offending user name excluded.

How to fix

To solve this problem, deselect the option Include dependencies in SQL Packager's options and build a new package executable. You will first need to upgrade to the latest version, SQL Packager 6.4, if you are not currently using it.

 After upgrading and removing the dependencies scripting from the options and excluding all users from the package that already exist in the database, the error should not occur.

If you continue to experience problems, please contact Red Gate Support.