Accessing multiple databases

Discussion in 'Databases' started by cgwp, Aug 27, 2010.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. cgwp

    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
     
    cgwp, Aug 27, 2010
    #1
  2. dmitri

    dmitri DiscountASP.NET Staff

    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.
     
    dmitri, Aug 27, 2010
    #2
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page