Post reply

How to change the login for an existing user?

  • May 12, 2003 at 4:56 pm

    #101474

    How to change the login for an existing user? I copied the mdn and ldb files from one server to another and attached the database. One of the database users is a owner of many objects. But this user does not appear in the security > login. When I try to add that user, it gives error 21002: [SQL DMO] User 'mav' already exists.

    How can I add this user using 'mav' as the login for the database?

  • May 12, 2003 at 6:12 pm

    #456909

    The user is orphaned. Look at BOL for info on sp_change_users_login, or you can do a search here on the site for tons of related articles and posts.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

  • May 12, 2003 at 6:57 pm

    #456912

    Thanks a lot

    It worked.

  • April 26, 2005 at 7:59 pm

    #555076

    Thanks Andy , this should be highlighted on this site It fixed my 21002 error with login (restored Db from Prod )

     

       

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply