none
Project server 2010 User migration from Domain_OLD to Domain_NEW RRS feed

  • Question

  • Hi,

    We have a Project server in Domain_NEW.

    Service accounts and Admin accounts are in Domain_NEW

    However Project Managers and Team Member Resources etc are in Domain_OLD accounts

    We would like to migarte these  Project Managers and Team Members etc to use Domain_NEW accounts

    Please suggest any procedure to perform this, we are using AD Group Resource Pool synch. If we replace Domain_OLD user in the AD group with Domain_NEW then it creates a new reosurce rather than updating the old account.

    Any help would be greatly appreciated.

    Tuesday, May 15, 2012 3:01 PM

Answers

  • In my scenario I came up with the following solution which worekd great

    Step1: Remove OldDomain AD Guid

    USE ProjectServer_Published
    UPDATE MSP_RESOURCES SET WRES_AD_GUID = NULL where WRES_ACCOUNT like 'OldDomain%'
    GO

    Step2: Change WRES_ACCOUNT to new domain

    UPDATE MSP_RESOURCES

    SET WRES_ACCOUNT = REPLACE(LTRIM(WRES_ACCOUNT), 'OldDomain', 'NewDomain') where WRES_ACCOUNT like 'OldDomain%';

    Step3: Change AD Group with new domain account or replace OldDomain accounts with NewDomain accounts in existing AD Group

    Step4: Re-Synch using New AD Group and make sure to Add Permissions to new Group

    Done :-)

    • Marked as answer by sssss555 Wednesday, May 16, 2012 9:02 AM
    Wednesday, May 16, 2012 9:02 AM