If you selected the Run Database Configuration option during installation, the Database Configuration wizard launches automatically after P6 Professional installation is complete. You can also run it manually at any time. Use Database Configuration to create a database connection for P6 Professional and Job Services.
You can also run Database Configuration manually at any time. See Running Database Configuration Manually for details.
Note:
- To change database connection settings, the Database Configuration wizard must access the PrmBootStrapV2.xml file. This file is located in
<local drive>\%LOCALAPPDATA%\Oracle\Primavera P6\P6 Professional\<version number>\
.
To run Database Configuration after installation, complete the following steps:
- If Database Configuration does not launch automatically, click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, Database Configuration.
- On the Select Driver Type dialog box, in the P6 Professional driver type field, select Microsoft SQL Server/SQL Express.
- In the Connection String field, enter the connection string to your database.
- If you are not using a named instance, enter the connection string in the format
<server name>,<port>/<database name>
.For example,
p6server.nesbidcorp.com,1234/PMDB
- If you are using a named instance, enter the connection string in the format
<server name>\<instance name>/<database name>
.For example,
p6server.nesbidcorp.com\primavera/PMDB
- If you are not using a named instance, enter the connection string in the format
- If your database is encrypted using a database key, in the Keystore section:
- If you want to use the default key for the database, select Use default database keystore.
- If you do not want to use the default key:
- In the Keystore file field, click Browse.
- In the Open dialog box, browse to your key file and click Open.
- In the Key Name list select the key to use.
- Click Next.
- In the Enter public login Information section, enter your public login information that was defined by your administrator.
Click Test to test the database connection. If the connection is successful, click Save. If the connection is not successful, revise the database connection information you provided.