Running Database Configuration Manually with a Microsoft SQL Server Database Driver
To run Database Configuration manually with a Microsoft SQL Server database driver, 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.
- Click Next.
- On the Select Database Alias Task dialog box, choose to either Modify an existing database alias or Create a new database alias.
- On the Select or Create Alias dialog box, select values for the following fields:
- In the Database alias field, enter a new alias. For example, PMDB.
- In the Driver type field, select Microsoft SQL Server / SQL Express.
- On the Configure SQL Server Connection dialog box, do the following:
- 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
.
- In the Database name field, enter the database name was specified when the database was created. For example,
PMDB
.
- On the Enter Public Login Information dialog box, enter your public login information that was defined by your administrator.
- On the Validate Database Connection dialog box, review the settings and click Next to test the database connection.
- If the connection is successful, click Finish.
If the connection is not successful, click Back to revise the database information.
Running Database Configuration Manually
Running Database Configuration Manually with an Oracle Database Driver
Running Database Configuration Manually with a Cloud Connect Database Driver