Skip to content
ProjectControls.com
Oracle Primavera - PM6

PMDB database configuration P6ver6.

In the Open Standard
Janaki Ram PithaniMember for 20 years
Created
7
4
0
Hi,

Can anybody pl tell me how to configure the PMDB database, driver type Microsoft SQL server/SQL Express.

when I tried to logon to P6 by entering the routine passowrd ’admin’, the message comesin asking me to configure the database. I just need to know the dababase userid and password. I hope somebody can have idea of this issue.

thanks
Save Follow Follow forum Report
Reply New topic

7 replies

Oldest first
  1. 0
    A D ·
    #1
    Use these settings:

    Host Name: COMPUTER_NAME\PRIMAVERA (or /, I dont recall exactly)
    Database name: PMDB$PRIMAVERA
    Username: pubuser
    Password: pubuser
    Public group ID: 1

    Cheers,
    Report
  2. 0
    Janaki Ram Pithani ·
    #2
    Thanks Raviraj, I tried but it didn’t work out and the following message appears.

    Bad public user name or password. Database Server Error: Login failed for user ’pubuser’.;
    Report
  3. 0
    Samer Zawaydeh ·
    #3
    Dear J,

    Try:

    Username: admin
    Password: admin

    Good luck,

    Samer
    Report
  4. 0
    Janaki Ram Pithani ·
    #4
    No Mr Sameer, It also didn’t workout. The following message follows.

    Bad public user name or password. Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [2]. ;

    Thanks
    Report
  5. 0
    A D ·
    #5
    Host Name?

    On my computer it is,

    RAVIRAJPC/PRIMAVERA

    Report
  6. 0
    Muhammad Anwar ·
    #6
    Janakiram

    Please try settings

    Host Name: localhost\primavera
    Database: pmdb$primavera

    User Name: privuser
    Password: privuser

    Public Id : 1

    if you have default users then it should work otherwise your username or password has been different. Then you have two options.
    1) reset the password by Sql server management studio
    or
    2) backup and reinstall the sql + primavera.

    Hope this will put you in right direction.

    regards

    Muhammad
    Report
  7. 0
    Sunder Rao ·
    #7

    Muhammad,Thaks a ton for the

    Muhammad,

    Thaks a ton for the help. Now I can connect P6 to SQL Server 2016.

    Sunder

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?