Post reply

relink AD usergroups after restore

  • June 4, 2004 at 3:17 am

    #163678

    Hello,

    I've restored a sql 2000 database in another Active Directory.

    Which result in broken users/logins. The usergroupnames are the same but the AD Domains are different. I mean to remembver that there was a stored procedure to fix this, but I can't find it anymore.

    Any idea?

    It was something like sp_fix_logins ('Database', 'OldDomain', 'NewDomain')

     

  • June 7, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 7, 2004 at 9:44 am

    #509274

    I think you'll want to begin your search with sp_change_users_login...

  • June 7, 2004 at 9:50 am

    #509276

    Script them out from EM, including db permissions, then search and replace with the new domain name.

    Then run the script.

    Then edit the original script for the drops only and remove the old logins WHEN YOU ARE SURE the new ones work. The only way to do this is recreate the new groups.

  • June 7, 2004 at 11:57 pm

    #509382

    The way Steve explains, work for me.

    Thanks.

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

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