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