Patrick Domingues

In this tutorial you will be shown how to install Oracle Primavera P6 EPPM v20. We will start with server installation and then end with a working client installation.

Prerequisites

The following prerequisites are a must to be configured and available.

• Windows Server 2019
• Microsoft SQL Server 2019 Express
• Microsoft SQL Server Management Studio (SSMS)
• Windows 10 Workstation

Let’s Get Started With Server Installation 

1. Decide which server you want to use.
2. If its a new server download and configure Windows Server 2019 and make sure its fully updated.
3. Download and Install Microsoft SQL Server 2019 Express. On the server and use the basic installation.
4. Download and install SQL Server Management Studio (SSMS) on the server.
5. Log into the Oracle Account 
6. Go to your downloads section and search for Primavera. During the creation of this tutorial the latest is 20.12 that was used. Download all the packages.
7. Transfer the file zipped folder P6_r2012_Database on the server containing Microsoft SQL Server 2019 Express. unzip its contents to a folder.
8. Download and install Java on the SQL Server.
    

   After installing the JDK, you must set the following environment variables to ensure the P6 EPPM installation scripts can locate your Java libraries:

   • JAVA_HOME
   • PATH

   Setting the Environment Variables in Microsoft Windows

   To set the JAVA_HOME and PATH environment variables in Microsoft Windows:

   1. Click Start, Control Panel, System, and then Advanced system settings.
      
   2. In the System Properties dialog box, on the Advanced tab, click Environment Variables.
   3. Add the JAVA_HOME environment variable:
      1. In the System Variables section, click New.
      2. In the Variable name field, enter JAVA_HOME.
      3. In the Variable value field, enter the location where the JDK software is installed (for example, C:\Program Files\Java\<java_version>)
      4. Click OK.
   4. Update the PATH environment variable to include the location of the Java executable files:
      1. In the System Variables section, select the PATH variable, and click Edit.
      2. In the Variable value field, insert %JAVA_HOME%\bin; in front of all the existing directories. Do not delete any existing entries; otherwise, some existing applications may not run.
      3. Click OK.
   5. Exit the Control Panel.
9. Open up folder P6_r2012_Database, locate and run as an administrator dbsetup.bat.
   

    

10. Now the Primavera Database Setup Wizard should have started up.
11. Select Install a new database, Server type is Microsoft SQL Server. Then press Next.
    
12. Things to consider: If you want to use the sa sql account you will have to enable it by using Microsoft SQL Server Management Studio software. If you would like to use default Windows Authentication Mode you can do so as well. 
13. Go to your windows firewall and within Windows Defender Firewall With Advanced Security allow a new inbound connection on TCP port 1433.
14. Open SQL Server Configuration Manager
    – 1 . Expend to Protocols for SQLEXPRESS
    – 2 . Right click on TCP/IP and click Properties.
    – 3 . Scroll Down and locate IP4, find Enabled, expand dropdown and select Yes.
    – 4 . Now within TCP Port use: 1433
    – 5 . Click apply and OK

    

15. Lets restart the SQL Server Service within SQL Server Configuration Manager. Click SQL Server Services. Locate SQL Server > Right Click > Restart.
    
16. Enter your connection information for your SQL server. Then press Next.
    If you get a connection error you need to verify if your using the correct password and SQL access is setup correctly.
    
17. In the Configure Microsoft SQL Server step all we have to do is give it a Database Name: PMDB and click Next.
    
18. Now lets Create SQL Server Users. This is very important that you document. Type password for both user accounts and click Next.
    
19. Type in your Administrator password and click Install. 
    
20. Once The setup wizard completes click Next
    
21. Then click FINISH

Lets Get Started With Client Installation

1. Log into your Windows 10 computer.
2. Locate the zip folder that has the P6_Pro_R2012 contents and unzip\move it to the Windows 10 Computer’s desktop.
3. Open up the folder and run P6ProfessionalSetup.exe
   
4. Once the installation window is open click Typical and click ok.
   
5. On this installation window, click Install.
   
6. In this window just keep Run Database Configuration checked and click ok.
   
7. You will now be prompted with the Database Configuration Window. It should have auto filled but if it hasn’t make sure your settings are as follows:
   1. Driver Type: Microsoft SQL Server/SQL Express
   2. Database Alias: PMDB
   3. YourServerName/PMDB
   4. Check mark: use default database keystore
   5. Do not test just click Next.

      

8. In this window we can type in the credentials required to access the database.
   • Username: pubuser
   • pw: whatever you set it to.
   • Public Group ID: 1
9. If everything checks out okay click test and you should get a Test Connection Is Successful message. Afterwards just click Save.
   
10. Once saved closed the Database Configuration window.
11. Now you can open up the P6 Professional 20 Software and type in your admin login info.
    

I hope this article was helpful, if you have any questions, please feel free to contact me. If you would like to be notified of when I create a new post, you can subscribe to my blog alert.

Patrick Domingues

See Full Bio