Red Gate forums :: View topic - PackageSQLException: The login already has an account under
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Packager 6
SQL Packager 6 forum

PackageSQLException: The login already has an account under

Search in SQL Packager 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
jamesklett



Joined: 28 Sep 2009
Posts: 9

PostPosted: Fri Oct 23, 2009 3:50 pm    Post subject: PackageSQLException: The login already has an account under Reply with quote

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
Back to top
View user's profile Send private message
Chris Auckland



Joined: 24 Oct 2006
Posts: 755
Location: Red Gate Software Ltd.

PostPosted: Mon Oct 26, 2009 12:02 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
jamesklett



Joined: 28 Sep 2009
Posts: 9

PostPosted: Mon Oct 26, 2009 1:42 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group