PRJ2000: How to Set Up DSNs for Microsoft Project Central By Using a SQL Database (268246)


The information in this article applies to:

  • Microsoft Project 2000
This article was previously published under Q268246

SUMMARY

This article describes the three places that you need to configure data source names (DSNs) for Microsoft Project Central to function properly when you use project views for a project plan that is saved to a database.

This article assumes that you have already established a database, and that you know the user name and password configuration.

MORE INFORMATION

Create a System DSN on the Client

  1. Create a sample Microsoft Project file.
  2. On the File menu, click Save As.
  3. Click ODBC.
  4. On the Machine Data Source tab, click New.
  5. Click either User Data Source or System Data Source, depending on your organizational needs, 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, such as Team DSN. The DSN name on the server and the DSN used to save the project plan must match. You may also type a description in the Description box.
  8. Click Next.
  9. Click to select either the Windows NT Authentication or the SQL Server Authentication check box, depending on your environment. If you select SQL Server Authentication, type a valid user account and password.
  10. Change the default database to the database where you intend to save your project plans, such as 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.

Create a System DSN on the Server

NOTE: You must have administrative access to the server that hosts Microsoft Project Central.
  1. 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.

    NOTE: You can now create a System DSN or a User DSN, depending on your organizational needs. The remaining steps are the same for both.
  4. Click either the User DSN or the System DSN tab.
  5. Click Add.
  6. Click SQL Server in the list of drivers, and then click Finish.
  7. In the Name box, type the name of your data source. This needs to be the same name that you used to configure the client-side DSN (such as Team DSN). You may also type a description in the Description box.
  8. Enter the name of the database server.
  9. Click Next.
  10. Click to select either the Windows NT Authentication or the SQL Server Authentication check box, depending on your environment. If you select SQL Server Authentication, type a valid user account and password.
  11. Change the default database to the database where you intend to save your project plans, 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.
  15. Close the Administrative Tools window.

Configure the DSN Within Microsoft Project Central

  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.
Modification Type:MajorLast Reviewed:10/17/2002
Keywords:kbhowto KB268246
©2002 Microsoft Corporation. All rights reserved.