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 Professional. The table below summarizes the settings.


ADMINISTRATOR_SETTINGS Settings
Setting Description: Points to the JDBC connection URL for a P6 Professional 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