Primavera P6 Professional : “Unable to connect to the database” error

When connect SQL database in Primavera P6 Professional, we usually have problem like:

  • Error Message:  Bad public user Name or password. SQL Server Error: [DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
  • Error message: Bad public user name or password. SQL Server Error: [DBNETLIB][ConnectionOpen (Invalid Instance()).] Invalid connection.;”
  • Error Message:  Bad public user name or password. Database Server Error: Login failed for user ‘pubuser’.

Below are some Reason and Solution:

CAUSE 1:
Incorrect hostname, instance or database name
Bad public user Name or password. SQL Server Error: [DBNETLIB [ConnectionOpen(Connect()).]SQL Server does not exist or access denied.;

The default configuration entries for a standalone installation are localhost\primavera for the server host name and PMDB$primavera for the database name.

FIX 1:
Click back to the Database Configuration and correct the database name or hostname or instance.

Primavera P6 Professional Unable to connect to the database error-1

Continue reading “Primavera P6 Professional : “Unable to connect to the database” error”

Advertisements

How to backup and restore Primavera P6 Oracle Express (XE) database

How to backup:

From the command prompt (go to ‘Start’ > ‘Run’ > type ‘cmd’ and click ‘OK’) using the format below

exp system/<password>@XE full=y file=<path>\xedump.dmp log=<path>\exp_xedump.log

Continue reading “How to backup and restore Primavera P6 Oracle Express (XE) database”