Configure the migration administrator account (Project Server 2010)
Applies to: Project Server 2010
Topic Last Modified: 2010-06-14
This article describes how to configure the Migration Administrator account when migrating your Microsoft Office Project Server 2003 data to Microsoft Office Project Server 2007. Configuring the migration administrator account is one of the pre-migration tasks that are required before performing the migration.
When you configure the Migration Administrator account, you must do the following:
Give the appropriate permissions to the migration administrator account.
Verify that the Migration Administrator account has proper access.
Give appropriate permissions to the Migration Administrator account
The Migration Administrator account is the account with which the migration is run. In other words, the P12migrationtool.exe command-line tool is run under this account. The account needs the following permissions:
Database reader permissions on the Project Server 2003 database(s).
Administrator permissions on the target Project Web Access site.
Adding the Migration Administrator account to the default (unaltered) "Administrators" security group should give all relevant permissions. If an enterprise resource with the same name or Windows account exists in Project Server 2003, the Migration Administrator account has to be made an enterprise resource as well.
System administrator privileges on the Office Project Server 2007 databases.
Adding the Migration Administrator account to the "SysAdmin" SQL Server group gives this permission. If the Migration Administrator account is the farm administrator on the Office Project Server 2007 farm, then this permission will already be available.
Verify that the Migration Administrator account has proper access
After installing Office Project Server 2007, you need to verify that your installation is functional before proceeding to migrate data to it. You can do this by performing the following tasks.
To verify that the migration administrator account has proper access
Using the Migration Administrator account, log on to the computer on which you have installed the migration tool.
Navigate to the Office Project Server 2007 version of Microsoft Office Project Web Access. Log on by using the Migration Administrator account and make sure that you can access any page in Office Project Web Access Server Settings. This ensures that when the migration tool tries to add data to Office Project Server 2007 by using the Migration Administrator account, it will succeed.
Start Microsoft Office Project Professional 2007, create a profile with the Migration Administrator account, and then connect to Office Project Server 2007 with that profile.
Create, save, and publish a project. Verify that you do not encounter any errors during this process. Delete the project when you are done.
Open SQL Query Analyzer, connect to the computer running SQL Server that is hosting the Project Server 2003 database(s), and log on using the Migration Administrator account. Verify that you can access data in each Project Server 2003 database.
Open SQL Query Analyzer, connect to the computer running SQL Server that is hosting the Office Project Server 2007 database(s), and log in using the Migration Administrator account. Verify that you have system administrator privileges.