PRJ2000: "Project Too Large" Error Selecting Portfolio Views in Microsoft Project Central for a Project Plan Saved to a Database (263509)

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.
4. Select the DSN name that you want from the list, and then click Modify Data Source.
5. Type the correct User ID and Password for that DSN.
6. Click OK in the upper-right corner of the window.
7. 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 "Resolution for Causes 2 and 3" 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:

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.