Configuring Database Instance Settings for On-Premises

You will use the database instance settings to specify information about your database, such as name, description, and schema.

To set your database instance settings:

Open the Primavera P6 Administrator.
In the Configurations drop-down list, select your configuration.
In the sidebar select Database.
1. In the Instance list, select Manage Instances....
  1. In the Manage Instances dialog box, hover over the instance that should be the default instance, click Row Actions then select Set Default to set the selected instance as the default instance.
    Note: You can also remove the default database.
2. In the Instance list, select your database instance.
In the General Settings section:
1. In the Name field, enter the name of this database instance.
  Notes:
  - This determines how the database instance name will appear on the P6 login page.
  - The name can be a maximum of 32 characters.
2. In the Description field, enter a description of this database instance.
  Note: The description can be a maximum of 128 characters.
3. In the Public Group ID field, enter the database group ID of the privileged user account that will access the database.
  The default value is 1.
4. In the User Name field, enter the name used to establish a connection to the database.
  The default value is pubuser, but if you created a custom Public User name, you must use your custom name.
5. In the Password field, enter the Public User password used to establish a connection to the database.
6. Select the Auto Start Services option to automatically start all services for this database when the application server starts.
  When this option is selected, all job services with a Concurrent Threads setting greater than zero will start when the application server starts.
  
  Select this option if you will use the Summarize or Apply Actuals features in P6 Professional.
  
  If you do not select this option, users must manually log in to the application before the services will start.
  
  Note: If you clear the Auto Start Services option, job services will not start until someone logs in to the application for the first time.

Related Topics