This article describes how to move an Office Project Server 2003 installation and a Windows SharePoint Services 2.0 installation to a different server. To do this, you have to move the original databases to the new server, and then you have to configure Project Server 2003 and Windows SharePoint Services 2.0.

To move an Office Project Server 2003 installation and a Windows SharePoint Services 2.0 installation to a different server, follow these steps.

Step 1: Move the Project Server 2003 database to the new server

1. Back up the Project Server 2003 database on the original server. To do this, follow these steps:
   1. On the original server, start SQL Server Enterprise Manager.
   2. Expand Microsoft SQL Servers, expand SQL Server Group, expand the server, and then expand Databases.
   3. Right-click ProjectServer, point to All Tasks, and then click Backup Database.
   4. In the SQL Server Backup - ProjectServer window, click Add.
   5. In the File name box, type the file path for the backup file, and then click OK.
   6. In the SQL Server Backup - ProjectServer window, click OK.
2. Restore the ProjectServer database to the new server. To do this, follow these steps:
   1. On the new server, start Enterprise Manager.
   2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server.
   3. Right-click Databases, point to All Tasks, and then click Restore Database.
   4. In the Restore as database box, type ProjectServer, and then click From device.
   5. Click Select Devices, click Add, click File name, type the location of the backup file, and then click OK.
3. In Enterprise Manager on the new server, expand ProjectServer, and then click Users.
4. Right-click MSProjectServerUser, click Delete, and then click Yes.
5. Right-click MSProjectUser, click Delete, and then click Yes.
6. In Enterprise Manager, expand Security.
7. Right-click Logins, and then click New Login.
8. On the General tab, type MSProjectServerUser in the Name box, configure the authentication information, and then click ProjectServer in the Database box to configure the ProjectServer database as the default database.
9. On the Database Access tab, click to select the ProjectServer check box under Permit.
10. Under Permit in Database Role, click to select the MSProjectServerRole check box, and then click OK.
11. Right-click Logins, and then click New Login.
12. On the General tab, type MSProjectUser in the Name box, configure the authentication information, and then click ProjectServer in the Database box to configure the ProjectServer database as the default database.
13. On the Database Access tab, click to select the ProjectServer check box under Permit.
14. Under Permit in Database Role, click to select the MSProjectRole check box, and then click OK.

Step 2: Move the Windows SharePoint Services database, and then configure Windows SharePoint Services on the new server

1. Back up the Windows SharePoint Services database on the original server. To do this, follow these steps:
   1. On the original server, start Enterprise Manager.
   2. Expand Microsoft SQL Servers, expand SQL Server Group, expand the server, and then expand Databases.
   3. Right-click wss, point to All Tasks, and then click Backup Database.
   4. In the SQL Server Backup - wss window, click Add.
   5. In the File name box, type the file path for the backup file, and then click OK.
   6. In the SQL Server Backup - wss window, click OK.
2. Restore the Windows SharePoint Services database to the new server. To do this, follow these steps:
   1. On the new server, start Enterprise Manager.
   2. Expand Microsoft SQL Servers, expand SQL Server Group, and then expand the server.
   3. Right-click Databases, point to All Tasks, and then click Restore Database.
   4. In the Restore as database box, type wss, and then click From device.
   5. Click Select Devices, click Add, click File name, type the location of the backup file, and then click OK.
3. On the new server, install Windows SharePoint Services, extend the site, and then create the default content database.
4. Start SharePoint Central Administration.
5. Under Virtual Server Configuration, click Configure virtual server settings.
6. Under Name, click the site that you extended in step 3.
7. Under Virtual Server Management, click Manage content databases.
8. Click Add a content database.
9. On the Add Content Database page, click Specify database server settings, type the name of the new database server, and then type the name of the Windows SharePoint Services database that you restored in step 2. For example, type wss.
10. In the Number of sites before a warning event is generated box, type 9000.
11. In the Maximum number of sites that can be created in this database box, type 15000.
12. Click OK.
13. On the Manage Content Databases page, click the default content database.
14. Click to select the Remove content database check box, and then click OK two times.
15. Close SharePoint Central Administration.
16. Double-click the Wsswiz.exe file to start the SharePoint Configuration Wizard for Office Project Server 2003. To configure Windows SharePoint Services for Office Project Server 2003, follow these steps.
    
    Note The Wsswiz.exe utility is located in the Support\Wsswiz folder of your Project Server 2003 installation location (CD-ROM or network location).
    1. In the SharePoint Configuration Wizard, click Next.
    2. In the extended virtual servers list, click your Web site, and then click Next.
    3. Type the required information, and then click Next. Note the Site Owner user name.
    4. When the SharePoint Configuration Wizard has sufficient information to configure Windows SharePoint Services, click Next.
    5. Click OK when you receive the following message:
       The SharePoint Configuration Wizard will now close while Setup restarts. The wizard will restart momentarily.
    6. Note the SharePoint Administration URL and the port number. Additionally, note the site URL for creating subwebs.
    7. Click Finish to close the SharePoint Configuration Wizard.

Step 3: Install Project Server 2003

1. Double-click the Setup.exe file in the root folder of your Project Server 2003 installation location to start Project Server 2003 Setup.
2. On the User Information page, enter your user information, and then click Next.
3. Click to select the I accept the terms in the License Agreement check box, and then click Next.
4. Type the installation location, and then click Next.
5. Configure the services that you want to install, and then click Next.
6. Click Connect to another existing database, type the database server name in the Database server box, type ProjectServer in the Database name box, and then click Next.
7. On the Enter connection information for View tables page, click Next.
8. On the Enter database account information page, type MSProjectServerUser in the first Logon name box, type the password in the Password box, type MSProjectUser in the second Logon name box, type the password in the Password box, and then click Next.
9. On the Enter Analysis Services connection information page, type the server information if you are implementing Analysis Services, and then click Next. If you are not implementing Analysis Services, click Enter this information later, and then click Next.
10. On the Select a Web site page, click Default Web Site, and then click Next.
11. On the Enter Web server address information page, verify that the information is correct, and then click Next.
12. On the Enter SMTP mail server information page, type the server information if you are implementing Simple Mail Transfer Protocol (SMTP) mail, and then click Next. If you are not implementing SMTP mail, click Enter this information later, and then click Next.
13. On the Connect to a Web server that is running the Microsoft Window SharePoint Services page, click Enter this information later, and then click Next.
14. In Choose an installation environment, click Enterprise, and then click Next.
15. On the Enter the Administrator password page, type the administrator password information, and then click Next.
16. On the Summary page, click Install.
17. On the Setup Completed page, click Finish.

Step 4: Set up a Windows SharePoint Services Administration identity for COM+

1. Start the Pscomplus.exe utility.
   
   Note By default, the Pscomplus.exe utility is located in the Program Files\Microsoft Office Project Server 2003\Bin\1033 folder.
2. Under Analysis Services (OLAP) Access Identity, click to clear the Process this identity update check box.
3. Under Windows SharePoint Services Administration Identity, type the user name that you used as the Site Owner of the Wsswiz.exe utility, and then type the password for the account.
4. Click Create/Update COM+ Apps, and then click OK.
5. Log on to Project Web Access by using the Administrator account that you configured when you installed Project Server 2003.
6. Click to select the I accept the terms in the License Agreement check box, and then click Next.
7. Under Administration overview, click Manage Windows SharePoint Services.
8. On the Connect to SharePoint Server page, type the SharePoint Administration URL and the port number information that you recorded when you ran the Wsswiz.exe utility in the SharePoint Central Administration URL box. Additionally, type the site URL for creating subwebs that you recorded in the Create a site under this SharePoint URL box.
9. Click Save Changes.

Troubleshooting information

After you move a Project Server 2003 installation and a Windows SharePoint Services installation to a different server, you may be unable to perform certain tasks. For example, you may receive an error message that resembles the following when you try to link a new issue to a project task in Microsoft Office Project 2007 or in Project Web Access:
This problem can occur if the Server Intranet Address setting in Project Web Access is incorrect. To resolve this problem, follow these steps:

1. Start Project Web Access.
2. Use the Administrator account to log on to Project Web Access, and then click Admin.
3. Click Server configuration.
4. In the Server intranet address box, type the correct Intranet address for the server, and then click Save Changes.