none
Domain account migration RRS feed

  • Question

  • Hi, here follows the current scenario:

    * Our farm is running MS Project Server 2007 SP1.

    * Our corporate, is migrating all accounts from DomainA to DomainB. For example, user DomainA\XXX will be migrated to DomainB\XXX.

    * DomainA and DominB are with trusts between them.

    I would like to know the possible consequences of this account migration (I think catastrophic) and whether there are tools or best practices able to support this use case.

    About migration on users I only know that sid user history will be preserved. But I'm not sure that Project Server will still recognize the correct user after migration has been performed.

    Thursday, April 19, 2012 7:24 AM

Answers

  • If you set project server to automatically synchronise users with the Project Workspaces then the Project workspaces will get updated with the correct accounts. use steps 13 and 14 from Brian Smiths post after you have updated the accounts in Project Server.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 19, 2012 3:57 PM
    Moderator

All replies

  • Hi there,

    Take a look at Brian Smith's post here:

    http://blogs.msdn.com/b/brismith/archive/2009/06/22/project-server-2007-migration-from-one-domain-to-another.aspx

    Another option rather that using the direct SQL method to update the users domain once the servers have been moved to the new domain, open all the users that are resources in the Enterprise Resource pool, insert the windows account into the view then do a find and replace (old domain for the new domain) then save the resource pool. Users that are not resources can be updated in PWA > Server Settings > Manage Users.

    I would test this fully on a test environment first.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 19, 2012 10:35 AM
    Moderator
  • What about stsadm migrateuser operation? Will this work with Project Server 2007?

    Emiliano

    Thursday, April 19, 2012 12:56 PM
  • That will only work for SharePoint not the Project Server users.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 19, 2012 3:08 PM
    Moderator
  • Ok, there are Enterprise Resource Pool users used in the WP projects.

    But we have also the SP users in the workspaces. Do you know whether migrateuser will work for the workspaces created in the Project Server?


    Emiliano

    Thursday, April 19, 2012 3:18 PM
  • If you set project server to automatically synchronise users with the Project Workspaces then the Project workspaces will get updated with the correct accounts. use steps 13 and 14 from Brian Smiths post after you have updated the accounts in Project Server.

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 19, 2012 3:57 PM
    Moderator
  • Hi, what about if "service user" will not be migrated? From the article you linked, I guess I would need only to accomplish these steps.

    A feedback is much appreciated. Thanks a lot

    A)

    In MSP_RESOURCES table of Published database, change the domain name of the users.

    Use the following query

    UPDATE MSP_RESOURCES

    SET WRES_ACCOUNT = REPLACE(LTRIM(WRES_ACCOUNT), '<Current Domain Name>', '<New Domain Name>');

    In this scenario, I used,

    UPDATE MSP_RESOURCES

    SET WRES_ACCOUNT = REPLACE (LTRIM(WRES_ACCOUNT), 'APAC', 'NORTHAMERICA');

    B)

    13. To initiate “User Synchronization for Project Web Access App Root Site and Project WSS Workspaces”, create a new Category (say “TestSync”) from on Server Settings, Manage Groups add users to this group ( do not add the currently logged in user ) and click save. Again, revert back the changes. Delete the newly created category.

    14. Once, “User Synchronization for Project Web Access App Root Site and Project WSS Workspaces” is succeeded, synchronize the Project Workspaces from Server Settings, Project Workspaces.

    15. Test the server by publishing a new project and existing project as well.

    16. Ask users to access the PWA and Project workspaces and test.


    Emiliano

    Thursday, April 26, 2012 3:38 PM
  • Hi there,

    There, what is the service user? Is this the farm account? The steps above look fine, Brian Smiths post will work :)

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 26, 2012 3:53 PM
    Moderator
  • Yes, with service user I mean the farm account (used also to run all services).

    Can I definitely rely on the few steps above to migrate users only? Do I forget something?

    Thanks


    Emiliano

    Thursday, April 26, 2012 4:05 PM
  • Once you have the PWA site accessbile using the steps in the blog post, the steps you have listed will give the users access to the PWA site / Project Workspaces.

    I would do a trial migration on a test farm first!

    Thanks

    Paul


    Paul Mather | Twitter | http://pwmather.wordpress.com

    Thursday, April 26, 2012 4:11 PM
    Moderator