How to Create Primavera P6 EPPM Database Schemas in Microsoft SQL Server

 

In this section, I have explained how to create a Primavera P6 EPPM Database Schemas in Microsoft SQL Server.

Follow the links If you are interested in Microsoft SQL Server Installation

Microsoft SQL Server 2017 Developer Edition Installation

Microsoft SQL Server Management Studio 2017 Installation

Open Microsoft SQL server Ports in Firewall

 

Creating Primavera P6 EPPM schemas in MS SQL Server

 

Follow the instruction to Create p6 EPPM schemas. Assume you have downloaded the Primavera P6 software or installed the Primavera P6 Home in your computer

 

1. Go to your P6_Home\database folder and double click on the database.bat file

 

021518_0348_HowtoCreate1 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

2. The Primavera database setup wizard will open on the screen like below

 

021518_0348_HowtoCreate2 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

3. Input the MS SQL Server database details (The user SA is the admin super account in MS SQL Server Database. Please refer the Step 15 of MS SQL Server DB Installation)

 

021518_0348_HowtoCreate3 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

4. Input database keystore if any or skip the details and click Next

 

021518_0348_HowtoCreate4 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

5. Click Next

 

021518_0348_HowtoCreate5 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

6. Input the PUBUSER, PRIVUSER AND PXRPTUSER password

 

021518_0348_HowtoCreate6 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

7. Input Primavera P6 application administration username and password, Load/Unload the sample P6 database and select the currency for the database

 

021518_0348_HowtoCreate7 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

8. Click Next once all are successful

 

021518_0348_HowtoCreate8 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

9. Click Finish Once Done

 

021518_0348_HowtoCreate9 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

10. Open the Microsoft SQL Server Management Studio >> Click Connect >> Input SA connection details >> Click Connect

 

021518_0348_HowtoCreate10 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

 

11. You will notice the database PMDB under the database & PUBUSER, PRIVUSER, PXRTPTUSER under Security > Logins as like below

 

021518_0348_HowtoCreate11 How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server

govindan How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server
Connect me
By | 2018-02-15T13:02:26+00:00 February 15th, 2018|Categories: P6|Tags: |Comments Off on How to Create Primavera P6 EPPM Database schemas in Microsoft SQL Server
Like us on Facebook.
Connect!