Package execution failing because the login already has an account under a different user name

Category: Troubleshooting & error messages
Date: 30 Oct 2009
Product: SQL Packager
Versions: 6.0
When executing a SQL Packager executable, the program can fail with the error "The login already has an account under a different user name."

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.

To solve this problem, you may de-select the option "Include dependencies" in SQL Packager's options and build a new package executable. Unfortunately, this option had been from the release of SQL Packager 6.0, so it is first necessary to upgrade your SQL Packager installation with a private release from our FTP site:

<ftp://support.red-gate.com/patches/SQL_Packager/SQL%20Packager_6.3.1.5_x86_r91109.zip>

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.

Document ID: KB200910000441 Keywords: sql,packager,login,exists,user,name

Was this article helpful?

Search support