Microsoft KB Archive/263509

= PRJ2000: &quot;Project Too Large&quot; Error Selecting Portfolio Views in Microsoft Project Central for a Project Plan Saved to a Database =

Article ID: 263509

Article Last Modified on 1/27/2007

-

APPLIES TO


 * Microsoft Project 2000 Standard Edition

-



This article was previously published under Q263509



SYMPTOMS
In Microsoft Project Central, when you select a project view, you may receive the following error message:

VBScript: Microsoft Project Central

An error occurred while trying to access the project on the database. Either the project is too large, or the Microsoft Project Central server may not have correct DSN configuration. Contact the server administrator.



CAUSE
This error message may occur when any of the following conditions is true:
 * 1) The System Data Source Name (System DSN) was created by using an Internet Protocol (IP) address to connect to the database server.
 * 2) The System DSN uses Microsoft Windows NT authentication to connect to a SQL database in which the database owner (DBO) uses SQL authentication.
 * 3) The System DSN created to connect to the MSDE database is using Microsoft Windows NT authentication.
 * 4) The project plan is saved by using a DSN to a Microsoft Access database.
 * 5) The User ID or password for the DSN are not correct in the Data Sources for Views page, in Microsoft Project Central.
 * 6) A User DSN is being used instead of a System DSN to save the project plan to the database.
 * 7) The DSN is damaged.
 * 8) The Oracle Open Database Connectivity (ODBC) driver is selected to connect to the Oracle database.
 * 9) The Administrator of Microsoft Project Central has set the authentication to either Windows Authentication Only or Microsoft Project Central Authentication Only.



RESOLUTION
To resolve this behavior, use the appropriate method for your situation.

Resolution for Cause 1
Make sure the DSN is configured to use the TCP/IP library. To do this, follow these steps:
 * 1) Create a sample project file in Microsoft Project.
 * 2) On the File menu, click Save As.
 * 3) Click ODBC.
 * 4) On the Machine Data Source tab, click New.
 * 5) Click System Data Source, and then click Next.
 * 6) Click SQL Server in the list of drivers, and then click Next. Click Finish.
 * 7) In the Name box, type the name that you would like for this connection. You may also type a description in the Description box.
 * 8) In the Server box, type the IP address of the server, and then click Next.
 * 9) Click Client Configuration.
 * 10) Under Network Libraries, click TCP/IP, and then click OK.
 * 11) Select the type of authentication that you are using.
 * 12) Type the logon ID and password, and then click Next twice.
 * 13) To finish creating the DSN, answer the remaining questions when prompted, and then quit the wizard.

Resolution for Causes 2 and 3
Create a System DSN that uses SQL authentication to authenticate against the database. To do this, follow these steps.

NOTE: To complete these steps, you must have administrative access to the server that hosts Microsoft Project Central.
 * 1) On the server, click Start, point to Settings, and then click Control Panel.
 * 2) Double-click the Administrative Tools icon (in Microsoft Windows 2000 only).
 * 3) Double-click the Data Sources (ODBC) icon.
 * 4) On the System DSN tab, click Add.
 * 5) Scroll down the list of drivers, and then click SQL Server. Click Finish.
 * 6) In the Name box, type the name of your data source. You may also type a description in the Description box.
 * 7) In the Server box, type the name of the database server.
 * 8) Click Next.
 * 9) Set the authentication to SQL Server Authentication; then type the user name and password that the server was set up to use. (The name SA with no password is the default for SQL Server.)
 * 10) Change the default database to Project_CentralDB, and click Next.
 * 11) Click Finish.
 * 12) Click Test Connection. After the connection is successfully completed, click OK.
 * 13) Click OK to quit the wizard.
 * 14) Close the Administrative Tools window.

Resolution for Cause 4
When you use a Microsoft Access database to save project plans, save the project plan to the database by using the file name instead of a DSN. If you are prompted, choose to append the information to the database when saving file information.

For more information about how to use an Access database to store your project files, click Microsoft Project Help on the Help menu, type export information to a database format in the Office Assistant or the Answer Wizard, and then click Search to view the topic. Then, click the Export to a Microsoft Access or Microsoft Project database subtopic.

Resolution for Cause 5
Enter the corrected information for the User ID and password in Data Sources for Views, in Microsoft Project Central. To do this, follow these steps:
 * 1) Log on to Microsoft Project Central as the Administrator.
 * 2) On the Actions menu, click Manage Views.
 * 3) On the Manage Views menu, click Data Sources for Views.

You are now viewing the Data Sources for Views window.
 * 1) Select the DSN name that you want from the list, and then click Modify Data Source.
 * 2) Type the correct User ID and Password for that DSN.
 * 3) Click OK in the upper-right corner of the window.
 * 4) Repeat this procedure for each DSN that has been used to save a project file.

Resolution for Cause 6
Create a System DSN that has the same name, account, and password information, on both the client and the Microsoft Project Central server. To do this, follow these steps:
 * 1) Create a sample project file in Microsoft Project.
 * 2) On the File menu, click Save As.
 * 3) Click ODBC.
 * 4) On the Machine Data Source tab, click New.
 * 5) Click System Data Source, and then click Next.
 * 6) Click SQL Server in the list of drivers, and then click Next. Click Finish.
 * 7) In the Name box, type the name of your data source. You may also type a description in the Description box.
 * 8) In the Server box, type the name of the database server.
 * 9) Click Next.
 * 10) Set the authentication to SQL Server Authentication; then type the user name and password that the server was set up to use. (The name SA with no password is the default for SQL Server.)
 * 11) Change the default database to Project_CentralDB, and click Next.
 * 12) Click Finish.
 * 13) Click Test Connection. After the connection is successfully completed, click OK.
 * 14) Click OK to quit the wizard.

Resolution for Cause 7
Delete the old System DSN and re-create a new System DSN with the same name, account, and password information. To do this, follow the steps in the &quot;Resolution for Causes 2 and 3&quot; section of this article.

Resolution for Cause 8
Use the Microsoft ODBC for Oracle Driver to connect to the Oracle database.

For more information about Oracle and Microsoft Project Central, please go to the following Microsoft Web site:

How to Create a Custom Database and Table Installation for Oracle

Resolution for Cause 9
Set the authentication for Microsoft Project Central to Mixed. To do this, follow these steps:
 * 1) Log on to Microsoft Project Central as Administrator.
 * 2) On the Actions menu, click Server Mode, under the Admin options.
 * 3) On the Server Mode page, click Single User, and then click Save Changes.
 * 4) On the menu bar, click Admin.
 * 5) Click Authentication Options.
 * 6) On the Authentication Options page, click Mixed, and then click Save Changes.
 * 7) On the menu bar, click Home.
 * 8) Repeat steps 2 and 3, except select Normal for the mode instead of Single User, in step 3.

Keywords: kberrmsg kbprb KB263509

-

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

© Microsoft Corporation. All rights reserved.