Error Bad Public Username Or Password. Database Server Error: Login Failed For User 'Pubuser'
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)
When attempting to connect to an alias with the database configuration utility
the following error occurs.
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)
The issue has the following business impact:
Due to this issue, users cannot connect to the P6 database
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