Use Database Configuration to change connection settings for the client module if your database server configuration changes. For example, if the database is moved to a new server, run Database Configuration to configure the connection to the new server.
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 manually, complete the following steps:
- Click Start, All Programs, Oracle - Primavera P6, P6 Professional <release level>, P6 Professional <release level> Help and Tools, Database Configuration.
- On the Database Configuration wizard, click Add to create a new alias.
- In the Database alias field, enter a name for the new alias.
- In the Driver type field, select the Microsoft SQL Server / SQL Express driver.
- 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.