Running Database Configuration Manually with a Microsoft SQL Server Database Driver

To run Database Configuration manually with a Microsoft SQL Server database driver, complete the following steps:

  1. If Database Configuration does not launch automatically, click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, Database Configuration.
  2. Click Next.
  3. On the Select Database Alias Task dialog box, choose to either Modify an existing database alias or Create a new database alias.
  4. On the Select or Create Alias dialog box, select values for the following fields:
    1. In the Database alias field, enter a new alias. For example, PMDB.
    2. In the Driver type field, select Microsoft SQL Server / SQL Express.
  5. On the Configure SQL Server Connection dialog box, do the following:
    1. In the Host Name field, enter the name of the computer or IP address where Microsoft SQL Server is installed, along with the port number. For example, localhost, 1733.
    2. In the Database name field, enter the database name was specified when the database was created. For example, PMDB.
  6. On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
  7. On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
  8. If the connection is successful, click Finish.

    If the connection is not successful, click Back to revise the database information.

Related Topics

Running Database Configuration Manually

Running Database Configuration Manually with an Oracle Database Driver

Running Database Configuration Manually with a Cloud Connect Database Driver



Legal Notices
Copyright © 1999, 2016, Oracle and/or its affiliates. All rights reserved.

Last Published Tuesday, October 04, 2016