Error Bad Public Username Or Password. Database Server Error: Login Failed For User 'Pubuser' (Doc ID 1534795.1)

Last updated on JUNE 29, 2016

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 6.2 and later
Microsoft Windows x64 (64-bit)
Microsoft Windows (32-bit)

Symptoms

When attempting to connect to an alias with the database configuration utility
the following error occurs.

ERROR
-----------------------
P6 error: Bad Public Username Or Password. Database Server Error: Login Failed For User 'Pubuser'

Also the following error will be visible in SQL SERVER Management Studio in case that is attempted to open the P6 database (running a query for example or checking the properties of the database)

The file "C:\Program Files\MSSQL\Primavera\MSSQL.2\MSSQL\DATA\PMDB_DAT.MDF" is compressed but does not reside in a read-only database or filegroup. The file must be decompressed. (Microsoft SQL Server, Error: 5118)


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot connect to the P6 database

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms