Microsoft KB Archive/819638

= You receive the &quot;Cannot read from the specified SharePoint database&quot; error message when you connect the SharePoint Team Services server to Microsoft Project Server =

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:

Microsoft Project Server cannot read from the specified SharePoint database. The reasons could be:

1. ComputerName\UserName does not have read permissions on the specified SharePoint database.

2. The database server and database name are not correctly specified.

3. The database server is down and cannot be accessed at this time.



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.

Method One: Run the SharePoint Configuration Wizard to Provision your SharePoint Team Services Site for Microsoft Project Server
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.</li> 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.</li> Go to step 1 to provision your SharePoint Team Services Site for Microsoft Project Server.</li></ol>

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

</li> Click Next to provision your SharePoint Team Services Web sites with the Microsoft Project Server components.

If you receive the following error message,

Failed to Create Database Role

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.</li> After the wizard has completed, you will receive a confirmation screen, that states the following: <ul>  </li>  </li>  </li>  </li>  </li></ul>

Note the information that is provided on the confirmation screen. You must have the information provided on the confirmation screen to complete step 10. After you receive the confirmation screen, connect SharePoint Team Services in Microsoft Project Web Access.</li> Log on to Microsoft Project Web Access as the Administrator.</li> On the Admin menu, click Manage SharePoint Team Services.</li> 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

</li> Click Save Changes to test the connection of SharePoint Team Services to Microsoft Project Server.

Note You may have to replace the  with the server name, IP address, or fully qualified domain name (FQDN) of your Microsoft Project Server computer to test connectivity.</li></ol>

Method Two: Grant the Designated Windows User Account DB_DataReader Rights to the SharePoint Team Services Database in SQL Server
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

<div class="moreinformation_section">

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.