Article ID: 819638
Article Last Modified on 2/5/2007
APPLIES TO
- Microsoft Office Project Web Access
- Microsoft Project Server 2002
SYMPTOMS
When you use Microsoft Project Server 2002 and you try to connect the SharePoint Team Services server to Microsoft Project Server, you may receive the following error message:
CAUSE
This problem may occur if either of the following conditions are true:
- You installed SharePoint Team Services, or have a previous installation of SharePoint Team Services from Microsoft Office XP, but you have not provisioned the SharePoint Team Services Web site for Microsoft Project Server.
- The Windows Account does not have database reader permissions to the SharePoint Team Services Database in Microsoft SQL Server.
RESOLUTION
To resolve this problem, use one of the following methods.
Note If you installed SharePoint Team Services, or you have a previous installation of SharePoint Team Services from Microsoft Office XP, but you have not provisioned the SharePoint Team Services Web site for Microsoft Project Server, use the following method to resolve the problem.
Run the SharePoint Configuration Wizard to provision your SharePoint Team Services Site for Microsoft Project Server.
To do this, follow these steps:
- On the Microsoft Project Server CD-ROM, double-click Setup.exe.
- On the Microsoft Project Server 2002 Setup screen, click SharePoint Configuration Wizard.
- You may receive a message that recommends that you to download the latest Office XP Service Pack. If you click OK, you must download the latest service pack for Office XP. If you click Cancel, and select to download the service pack later, continue to run the SharePoint Configuration Wizard.
- Click Provision Additional Websites for Microsoft Project Server, and then click Next.
- Select the Web site that you want to provision. For example, you can select Default Website.
Note If you have created a new Web site specifically for SharePoint Team Services, but it is not listed in the menu to select a Web site, cancel the wizard and follow these steps:- Click Start, point to Programs, point to Administrative Tools, and then click Microsoft SharePoint Administration.
- In the Virtual Folders section, locate your new SharePoint Web site. In the last column, next to Versions, click Extend.
- Type the name of your database server. Type the username that has SQL administrator permissions, and then type the password. Accept the default Site Type value, and then click Submit.
- Go to step 1 to provision your SharePoint Team Services Site for Microsoft Project Server.
For additional information about how to provision SharePoint sites for Microsoft Project Server, click the following article number to view the article in the Microsoft Knowledge Base:
810598 How To Provision SharePoint Sites for Microsoft Project Server
- Click Next to provision your SharePoint Team Services Web sites with the Microsoft Project Server components.
If you receive the following error message,click OK.
Note This message may appear three times. This message appears because the database role was created during your initial installation of SharePoint Team Services.
- After the wizard has completed, you will receive a confirmation screen, that states the following:
Server NameWeb Server PortSharePoint Administration PortDatabase Server NameDatabase Name
- Log on to Microsoft Project Web Access as the Administrator.
- On the Admin menu, click Manage SharePoint Team Services.
- On the Connect to Servers page, type your SharePoint Team Services confirmation information. The confirmation information is processed after you install the Stswiz.exe file from the Microsoft Project Server CD-ROM.
Note You must run the Pscom+.exe utility and DB_DataReader rights must be granted to the SharePoint Database in SQL Server before you connect SharePoint Team Services to Microsoft Project Server. For additional information about the installation and connection of SharePoint Team Services to Microsoft Project Server, click the following article number to view the article in the Microsoft Knowledge Base:322235 PSRV2002: How to Install and Configure SharePoint Team Services for Microsoft Project Server on Windows 2000
- Click Save Changes to test the connection of SharePoint Team Services to Microsoft Project Server.
Note You may have to replace theServerNamewith the server name, IP address, or fully qualified domain name (FQDN) of your Microsoft Project Server computer to test connectivity.
Note If the Windows Account does not have database reader permissions to the SharePoint Team Services Database in SQL Server, use the following method to resolve the problem.
Grant the designated Windows user account DB_DataReader rights to the SharePoint Team Services database in SQL Server
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
819642 How to Configure SharePoint Team Services for Microsoft Project Web Access
MORE INFORMATION
For more information about the configuration of SharePoint Team Services and Microsoft Project Server, click the following article number to view the article in the Microsoft Knowledge Base:
322235 PSRV2002: How to Install and Configure SharePoint Team Services for Microsoft Project Server on Windows 2000
For more information about SharePoint Team Services, click the following article number to view the article in the Microsoft Knowledge Base:
331971 SharePoint Team Services admin operation in Microsoft Project Web Access does not work
Keywords: kbprb KB819638
