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

Previous TopicNext TopicContents

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

P6 Professional Installation

Database Client Software

About the P6 Professional Setup Wizard

Previous Versions of P6 Professional

Installing the P6 Professional Application for Typical Use

About the Database Configuration Wizard for P6 Professional

Configuring Client Machines to Transfer Data Between P3 and P6 Professional

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

Connect P6 Professional to a Contract Management HTTPS URL

Configuring P6 Professional to Connect to a Contract Management HTTPS URL

Configuring P6 Professional Internal Plug-ins for Authentication



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

Last Published Thursday, February 04, 2016

PDF Library