Manual SQL Server Database Configuration Overview

The P6 Professional database stores all P6 Professional data used by all P6 Professional applications.

P6 Professional supports Oracle and Microsoft SQL Server databases. See Client and Server Requirements for details on which versions are supported. The Microsoft SQL Server or Oracle server software must be installed on the database servers before you can create the database.

Notes:

P6 Professional includes an encryption algorithm that provides enhanced security for private database logins; however, the encryption algorithm is not automatically enforced when you manually configure or upgrade your database. If you manually configure or upgrade your database, Oracle recommends that you use this encryption algorithm. To do so, you must reset the private database login. See Resetting Private Database Passwords to Use the New Encryption Algorithm for instructions. If automatically installing or upgrading your database, no configuration is needed after the upgrade to use the encryption algorithm. User logins and passwords are not affected.

Tips

P6 Professional does not support passwords with multi-byte characters.
See Automatic Database Upgrade Considerations and Prerequisites for instructions on automatically upgrading your databases to the current version if you have manually configured P6 Professional databases for an earlier version. If you want to manually upgrade your databases, see the Manually Upgrading the P6 Professional Database for Microsoft SQL Server document.
For security reasons, Oracle strongly recommends that you replace the default database users' (privuser and pubuser) passwords immediately after a manual database installation or an upgrade from P6 version 7.0 and earlier. Do not use special characters in the database name, privileged user, or public user name for example: { } [ ] : ; < > , . ? ! @ # $ % ^ & * ( ) - _ | / \ ~ ` _
Oracle recommends using strong passwords. Strong passwords in P6 Professional are defined as passwords containing between 8 and 20 characters and at least one numeric and one alpha character. To further strengthen the password, use a mixture of upper and lower case letters.
See Modifying Private Database Logins for P6 Professional for instructions on how to replace the private database login. For all other database user names and passwords, use the tools included with Microsoft SQL Server.
For security reasons, Oracle strongly recommends that you replace the default Admin Superuser (admin) immediately after a manual database installation or an upgrade from P6 version 7.0 and earlier.
If you wish to prevent the appearance of duplicate values in P6 Professional modules due to leading or trailing spaces, ensure that the ANSI_PADDING setting in Microsoft SQL Server is set to OFF. For example, if one user enters "Equipment" and another user enters " Equipment" (with a leading space) for resource codes, the database will store both of these as valid values if ANSI_PADDING is set to ON. If ANSI_PADDING is set to OFF, the database will remove the leading space in the second entry and warn the user that a unique ID must be entered. See the documentation included with Microsoft SQL Server for more information.
A SQL database name must not contain a space.

Related Topics