none
Project server 2010: Configuring two different domains in one Project Server application RRS feed

  • Question

  • Hi,

    We have a Project server 2010 set-up and users from one domain say "domain1/user" are accessing and filling their timesheet using the application.

    Now some of the domain1 users have been shifted to domain2.

    we have a requirement to allow shifted users from another domains say "domain2/user" to continue their access and timesheet filling as usual.

    If I just update the Login details in the backend, will this work?

    Kindly suggest.

    Monday, April 6, 2015 8:50 AM

Answers

  • Hi GanuInMumbai,

    No PSI code is needed.

    First you have to change users authentication for sharepoint, as not all you users are migrated to Domain2, you have to migrate user per user.

    1-

    $user = Get-SPUser -web http://server/pwa -Identity "Domain1\user"
    Move-SPUser -IgnoreSID -Identity $user -NewAlias "Domain2\user"

    2-  until now user account is not changed in PWA, and you can't change it from PWA setting, so from SQL Server , execute this sql script

    User ProjectServer_published

    UPDATE MSP_RESOURCES

    SET WRES_ACCOUNT = REPLACE (LTRIM(WRES_ACCOUNT), 'Domain1\', 'Domain2\') where WRES_ACCOUNT like '%user%' 

    Hope this will help you.


    Jalal Blali MCTS, MCITP






    • Edited by Jalal blali Thursday, April 9, 2015 6:31 PM
    • Marked as answer by GanuInMumbai Monday, April 13, 2015 5:57 AM
    Thursday, April 9, 2015 1:43 PM

All replies

  • Hi

    Don't update anything from backend and Its not recommended

    Follow below steps to change the domain names

    1. Logon PWA with Admin rights

    2. click on Resource center from quick launch menu

    3. select the list of users (needs to change the domain name) and click OPEN under resource ribbon, then selected users opens in MS Project 2010 as Checked out Enterprises Resources

    4. Insert a column called "Windows User Account", here you can change from domain1\user to domain2\user

    5. Save and close

    Hope it helps

    Regards

    Santosh

    • Marked as answer by GanuInMumbai Tuesday, April 7, 2015 6:35 AM
    • Unmarked as answer by GanuInMumbai Thursday, April 9, 2015 5:53 AM
    Monday, April 6, 2015 9:35 AM
  • Hi,

    Can we achieve this using PSI?


    Thursday, April 9, 2015 5:53 AM
  • Yes its possible and it would be simple PSI code

    I recommend you to write PSI code using WCF.

    Download Project SDK and have a glimpse on that. it contains methods, events, sample codes, syntax.. etc

    Regards

    Santosh

    Thursday, April 9, 2015 7:16 AM
  • Hi GanuInMumbai,

    No PSI code is needed.

    First you have to change users authentication for sharepoint, as not all you users are migrated to Domain2, you have to migrate user per user.

    1-

    $user = Get-SPUser -web http://server/pwa -Identity "Domain1\user"
    Move-SPUser -IgnoreSID -Identity $user -NewAlias "Domain2\user"

    2-  until now user account is not changed in PWA, and you can't change it from PWA setting, so from SQL Server , execute this sql script

    User ProjectServer_published

    UPDATE MSP_RESOURCES

    SET WRES_ACCOUNT = REPLACE (LTRIM(WRES_ACCOUNT), 'Domain1\', 'Domain2\') where WRES_ACCOUNT like '%user%' 

    Hope this will help you.


    Jalal Blali MCTS, MCITP






    • Edited by Jalal blali Thursday, April 9, 2015 6:31 PM
    • Marked as answer by GanuInMumbai Monday, April 13, 2015 5:57 AM
    Thursday, April 9, 2015 1:43 PM
  • Hi,

    Thanks for the help!!!

    We figured out updating the login id using PSI.

    We can implement using the ResourceAuthorizationDataSet  using PSI.


    Monday, April 13, 2015 5:57 AM