Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Posts
    52

    Unanswered: Question about adding new log in??

    I hope I can explain this.......
    I restored a database "GIM" from server 1 to server2. That went OK. However, there is user A on server 1 who has db_owner access to database "GIM". After the restore, I
    add user A on server 2 and try to give him db_access to
    database "GIM".

    I got the error message saying that "User A already
    exists in server2". But user A was not there.

    What did I do wrong? Thank you for your suggestions.

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Expand GIM database in EM and click on Users. Right-mouse click on [user A] and select Delete. After that expand Security and click on Logins, right-mouse click on [User A] and assign database access in Database Access tab.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jan 2005
    Location
    TempDb
    Posts
    228
    I love deadlines. I like the whooshing sound they make as they fly by. Douglas Adams

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •