"The login already has an account a different user name

Jim Covington

I am attempting to update an existing database with SQL Packager.

I get the following error. I have deleted the target Database and rerun, but no luck.

"The login already has an account under a different user name"

What is the problem?

Jim

Brian Donahue

Hi Jim,

It sounds as if the Package is running sp_adduser to put a new user onto the server. If you want to clean things out so that the package will run successfully, you'll probably want to delete the user's login from security in Enterprise Manager. Of course, you'll want to make sure that the user isn't needed in another database elsewhere!

Dropping the database only removes the user from the database, but it will still exist on the server.