In Microsoft Windows, users are a composite of the domain name or computer name, and the user name, for example Computer1\WindowsUser1. SQL Packager references both parts of the name.

However, SQL Server references only the user name, so that Computer1\User1 and Computer2\User1 would be considered as the same. Therefore, if SQL Packager attempts to create a user for which the computer name is different but the user name is the same, SQL Server returns an error.

How to fix

To avoid this error, ensure that the user names are different for users that you want to upgrade.

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