Error 21002: [SQL/DMO]User 'usernamehere' already exists.

[ryufireblade]

Just curious if anyone has gotten this error when you set the database access in sql server 2000, windows xp? Under the sql server login properties, database access, I check the box next to the account database and check the db_owner under the database roles for "account", I hit ok and I get this error,

Error 21002: [SQL/DMO]User 'usernamehere' already exists.

Any ideas on how to fix this?

[=Warmonger=]

Originally Posted by ryufireblade

Just curious if anyone has gotten this error when you set the database access in sql server 2000, windows xp? Under the sql server login properties, database access, I check the box next to the account database and check the db_owner under the database roles for "account", I hit ok and I get this error,

Error 21002: [SQL/DMO]User 'usernamehere' already exists.

Any ideas on how to fix this?

account database -> users -> delete account

[ryufireblade]

Originally Posted by Warmonger1337

account database -> users -> delete account

That did the trick. I had to do this for the billing, cash, and character databases too. Thanks Warmonger!

Solved, can be closed.