Configuring the P6 EPPM Database Connection on a Microsoft SQL Server Database

Previous TopicNext TopicContents

Use the instructions in this section only if your P6 EPPM database is on a Microsoft SQL server. You must have already installed the Oracle Gateway software before installing the Primavera P6 Reporting Database software. See Configuring the Oracle Database Gateway to Link to a P6 EPPM Database on a Microsoft SQL Server System for information about installing the gateway.

  1. On the Welcome screen, click Next to begin.
  2. On the EPPM Reporting Database Connection screen:
    1. For the Database Type option, choose SQL Server.
    2. In the SQL Server Connection section:
      1. In the Host Name field, enter the server machine name or IP address where you installed the P6 EPPM database.
      2. This is the SQL Server instance name of the Microsoft SQL Server where the P6 EPPM database resides. For example, SQLServerName\databaseInstanceName.
      3. In the Port Number field, enter or verify the port number for this database.

        The default for Microsoft SQL Server is 1433.

      4. In the Database Name field, enter the name of the P6 EPPM database. This database must already exist.
    3. In the Oracle Gateway Connection section:
      1. In the Host Name field, enter the machine name or IP address where you installed the Oracle Gateway.
      2. In the Port Number field, enter the port number where you installed the Oracle Gateway.
      3. Choose the Service Name or SID option. Enter the Service Name or SID.
    4. In the Reporting User section:
      1. In the Username field, enter or verify your P6 EPPM reporting database name (for example, PxRptUser).
      2. In the Password field, enter the password for the reporting database user.
  3. Click Next.

    When you click next, the wizard will test that the connection is valid. If the test fails, ensure you have entered all the information correctly and try again.

Related Topics

Configuring the Oracle ODS Database

Configuring the P6 EPPM Database Connection on an Oracle Instance

Configuring the ODS Database Connection

Configuring ETL Settings for ODS

Finishing the Configuration Wizard for ODS

Finishing the ODS Database Configuration



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

Last Published Friday, January 31, 2014