Running Database Configuration Manually

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, which is located in <local drive>\%LOCALAPPDATA%\Oracle\Primavera P6\P6 Professional.

To run Database Configuration manually, complete the following steps:

1. 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.
2. Click Next.
3. On the Select Database Alias Task dialog box, choose to either Modify an existing database alias or Create a new database alias.
4. On the Select or Create Alias dialog box, select values for the following fields:
   1. In the Database alias field, enter a new alias. For example, PMDB.
   2. In the Driver type field, select the Microsoft SQL Server / SQL Express driver.
5. On the Configure SQL Server Connection dialog box, do the following:
   1. In the Host Name field, enter the name of the computer or IP address where Microsoft SQL Server is installed, along with the port number. For example, localhost, 1733.
   2. In the Database name field, enter the database name was specified when the database was created. For example, PMDB.
6. On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
7. On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
8. If the connection is successful, click Finish.

   If the connection is not successful, click Back to revise the database information.