"The login already has an account a different user name

Jim CovingtonJim Covington Posts: 2
edited February 18, 2005 11:34AM in SQL Packager Previous Versions
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

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    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.
This discussion has been closed.