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.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.|||Go here to understand why this happens. (http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment