Accessing multiple databases

[cgwp]

I would like to have a db user that can access either of the 2008 R2 databases I have. I've created a login using the login manager in the control panel. Then, per the KB article on the subject, I used 2008 Management Studio to create a user for the first database. This worked fine and I can use the login to access the database. Then I tried to assign the same login as a new user on the second system. I got an error saying "the login already has an account under a different user".

Any help would be appreciated.

Thanks

marc

[dmitri]

I think that you created two database users in the same database and trying to assign both of them to the same additional SQL Login.

SQL Login can be mapped to many database users, but those users must belong to different databases.