locked
Project Server 2010 Domain Migration RRS feed

  • Question

  • Hi All, 

    I have on-premises Microsoft Project Server 2010 with one Application Server and one Web Servers with SQL Server 2008 R2 Fail-over Cluster

    We have deployed new Windows Forest Active Directory for example.

    Currently domain is ABC.COM it will be replaced with XYZ.COM

    So Later we have to join new domain and current domain will be down, I searched a lot and found too many things, but is there any one who performed same activity on (SharePoint or on Project Server). 

    Kindly share your experience and suggest me the best way.

    I hope to hear from you guys soon. Thanks 


    Wednesday, October 25, 2017 7:27 AM

Answers

  • --  Update Resource Profile
    USE  ProjectServerTest_Published
    -- Update resource profile domain names.
    UPDATE MSP_RESOURCES
    SET
    WRES_ACCOUNT = REPLACE (WRES_ACCOUNT, 'olddomain\', 'newdomin\'),
    WRES_CLAIMS_ACCOUNT = REPLACE(WRES_CLAIMS_ACCOUNT, 'olddomain\' , 'newdomain\') 
    WHERE
    WRES_ACCOUNT IS NOT NULL
    AND LEFT(WRES_ACCOUNT,11) <> 'newdomain\'


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by hachishti Thursday, March 8, 2018 5:52 AM
    Thursday, November 9, 2017 3:58 AM
  • Along with Michael's response to update the user logon account, you will be performing the following as well

    • Setup New Synchronization connection for this Active Directory and setup the sync. This will help to update the email address and other details as necessary. 
    • If you have any user groups created (e.g. Project Managers) - you might need to re-validate those group members if they get updated with the right domain accounts.

    Thanks
    Sakthi


    Sakthi Ganesh

    • Marked as answer by hachishti Thursday, March 8, 2018 5:52 AM
    Tuesday, November 21, 2017 3:37 PM

All replies

  • Yes, I have done this several times in the past.  It requires editing the Resource tables using SQL update and replacing the old domain names with the new domain name.  I can't recall the table names, but it seems like there were two tables found in the publish database.

    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    Wednesday, October 25, 2017 10:37 AM
  • Hi Mr. Wharton, 

    I am so glad to see your reply and prompt response.

    Do you have any step by step guide, blog, article.

    A part from that, how we remove the duplication from the published database.

    I saw in one technet article that after domain migration on Project Server user will face some issues like error messages on PDP, error in project publishing, dulication of accounts and page not found error page on project site home page.

    Thank you so much for your help and support. 

     

      

    Wednesday, October 25, 2017 11:13 AM
  • --  Update Resource Profile
    USE  ProjectServerTest_Published
    -- Update resource profile domain names.
    UPDATE MSP_RESOURCES
    SET
    WRES_ACCOUNT = REPLACE (WRES_ACCOUNT, 'olddomain\', 'newdomin\'),
    WRES_CLAIMS_ACCOUNT = REPLACE(WRES_CLAIMS_ACCOUNT, 'olddomain\' , 'newdomain\') 
    WHERE
    WRES_ACCOUNT IS NOT NULL
    AND LEFT(WRES_ACCOUNT,11) <> 'newdomain\'


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by hachishti Thursday, March 8, 2018 5:52 AM
    Thursday, November 9, 2017 3:58 AM
  • Along with Michael's response to update the user logon account, you will be performing the following as well

    • Setup New Synchronization connection for this Active Directory and setup the sync. This will help to update the email address and other details as necessary. 
    • If you have any user groups created (e.g. Project Managers) - you might need to re-validate those group members if they get updated with the right domain accounts.

    Thanks
    Sakthi


    Sakthi Ganesh

    • Marked as answer by hachishti Thursday, March 8, 2018 5:52 AM
    Tuesday, November 21, 2017 3:37 PM