PackageSQLException: The login already has an account under

[jamesklett]

Trying to build a package from my local DB Server-DB and resatore to same local Server with different DB name. I get this error "The login already has an account under a different user name." The odd thing though is I deselected all the logins from the package setup

Ideas?

Thanks,

JIM

[Chris Auckland]

Thanks for your post.

This is probably because the release version of SQL Packager 6 always uses the 'include dependencies' option.

If you have any objects that have a dependency to a user, SQL Packager will always bring the deselected user back into the synchronization.

We have a patch release that enables you to turn off this option. Can you try it out and let me know if it helps or not?

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

[jamesklett]

Thanks for the response, that appears to work. Thanks you for that. One cool benefit of using the Packager I have found is that it will discover any errors in Views or SProcs upon restore. My test resotore found about 15 bugs in stored procedures.

JIM