Database Administrator Settings for a Non-Default Microsoft SQL Server Port

To enable users to utilize P6 Integration API functionality within P6 Professional when using a non-default Microsoft SQL Server port, add an ADMINISTRATOR_SETTINGS row to the SETTINGS table for each Microsoft SQL Server database you use with P6 EPPM. The table below summarizes the settings.

ADMINISTRATOR_SETTINGS Settings

Setting Description: Points to the JDBC connection URL for a P6 EPPM Microsoft SQL Server database.

Namespace

Administrator_Settings

Setting Name

JdbcConnectionURL

Setting Value

<jdbc connection url>

When entering a value for jdbc connection url for Microsoft SQL Server, use the standard connection string. For example:

jdbc:sqlserver://<servername>:<portnumber>;database=<databasename>;

Related Topics

Installing P6 Professional

Database Client Software

Running the Installation Wizard

Running Database Configuration After Installation

Updating the Path System Variable for the P6 Professional SDK

Set the Industry Type (P6 EPPM Only)

Installing Local Copies of P6 Professional and Visualizer Help

Configuring Client Computers for a Non-Default Microsoft SQL Server Port

Configuring P6 Professional Internal Plug-ins for Authentication



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

Last Published Tuesday, October 04, 2016