Installing a P6 EPPM Database with Microsoft SQL Server

If you want to manually install P6 EPPM, you should install a P6 EPPM database using the Primavera Database Setup Wizard.

To install a P6 EPPM database using the Primavera Database Setup Wizard:

1. To open the Primavera Database Setup Wizard, run dbsetup.bat (with Windows) dbsetup.sh (with UNIX or Linux) at <P6_EPPM_Home>/database where <P6_EPPM_Home> is the P6 EPPM home directory that was set during installation.

   Note: Click Next after each of the following steps.

2. On the Primavera P6 screen, complete the following:
   1. Select Install a new database.
   2. Select Microsoft SQL Server.
3. On the Connection Information screen, enter the connection details for a Microsoft SQL Server database and the administrative database user.
4. On the Configure Microsoft SQL Server screen, complete the following:
   1. Enter the name of the P6 EPPM database.
   2. Enter the location of the Data and Log files.
   3. Select the database code page. The default is Database default.
   4. Enter the location of the keystore.
5. On the Create New Keystore screen, complete one of the following:
   • If you want to use an existing keystore, enter the password in the Existing Keystore Password field.
   • If you are creating a new keystore, do the following:
   1. Select Create New Keystore.
   2. In the Enter Keystore Password field, enter a password for the new keystore.
   3. In the Confirm Keystore Password field, enter the new password again for verification.
   • If you do not want to create a keystore and you do not have an existing keystore, ensure all fields are clear.
6. On the Create SQL Server Users screen, complete one of the following steps:
   • If you want to use the existing P6 EPPM users for P6 Professional, complete the following:
     1. Select the Use Existing check box.
     2. In each User Name list, select the username of the database user.
     3. In each Password field, enter the password for each database user.
   • If you want to create database users for P6 Professional, enter the login credentials for each database user in the User Name, Password, and Confirm Password fields.
7. On the Configuration Options screen, complete the following:
   1. Enter a name and password for an administrative application user.
   2. Choose whether or not you want to load sample data.
   3. Select your currency from the Currency list.
   4. Click Install.

Related Topics

Setting Up the P6 EPPM Database

Installing a P6 EPPM Database with Oracle

Upgrading a P6 EPPM Database with Oracle Database

Upgrading a P6 EPPM Database with Microsoft SQL Server

Legal Notices | Your Privacy Rights
Copyright © 1999, 2023

Last Published Thursday, January 12, 2023