This document describes how to manually install Oracle Primavera P6 EPPM and use a Microsoft SQL Server database
This guide provides instructions for database administrators to manually install Oracle Primavera P6 EPPM using Microsoft SQL Server. It covers creating the database structure, copying scripts, setting up users and tables, installing sample data, and configuring security settings. The guide assumes familiarity with SQL Server administration and command-line tools. It also includes tips for optimizing SQL Server settings and securing database credentials.
| Database Name | PMDB |
|---|---|
| Default Admin Superuser | admin |
| Default Users | admuser, privuser, pubuser, bgjobuser, and PxRptUser |
| Password Requirements | 8 to 20 characters, at least one numeric and one alpha character, mixture of upper and lower case letters |
| SQL Server Setting: ANSI_PADDING | Off |
| SQL Server Setting: Max Worker Threads | Default (255) or lower |
| SQL Server Setting: Memory | Dynamic |
| SQL Server Setting: Open Objects | Dynamic |
| SQL Server Setting: User Connections | 0 |
| SQL Server Setting: Network Packet Size | 16384 |
| SQL Server Setting: FILESTREAM | Enabled |
The default database name is PMDB.
The default database users are admuser, privuser, pubuser, bgjobuser, and PxRptUser.
Passwords must be between 8 and 20 characters, include at least one numeric and one alpha character, and use a mixture of upper and lower case letters.
The ANSI_PADDING setting should be set to Off to prevent duplicate values due to leading or trailing spaces.