Skip to content
ProjectControls.com
Planning, Scheduling & Programming Discussion

P6 Unable to configure SQL Database after Computer Crash

In the Open Standard
Dewald de VlaminghMember for 14 years 4 months
Created
3
4
0

Hi

My hard drive crashed & I am having a hard time setting up my database again. It was backed up & successfully restored, however, when I open P6 I have to set up the database. I then try logging in with - 
Host Name - PCNAME\PRIMAVERA
Database name - pmdb$primavera
Username - pubuser
Password - pubuser

I have also tried with username & password 'pivuser' without success.

I get the message that reads - >Bad public user name or password. Database Server Error: Login failed for user 'pubuser'. Cannot open database "pmdb$primavera" requested by the login. The login failed.;<

I am using P6.7

I would much appreciate any help.

Save Follow Follow forum Report
Reply New topic

3 replies

Oldest first
  1. 0
    Forest Peterson ·
    #1

    These are the notes I use to

    These are the notes I use to reset database issues:

    PMDB
    database name: pubuser
    database password: pubuser
    alternate:
    database name: privuser
    database password: privuser

    SDB (SQL database)
    host: [localhost]\primavera
    database name: pmdb$primavera
    username: sa
    password: prima (alt password: Prima123Vera)

    Report
  2. 0
    Dewald de Vlamingh ·
    #2

    Gentleman Thank you for your

    Gentleman

     

    Thank you for your reply!

    I manage to sort out my problem.

    Here are the steps I took - 

     

    Open Microsoft SQL Server Management Studio Express
     
    Log in using SQL Server Authentication
    Username - SA
    PSW - Prima123Vera
     
    Expand the Databases Folder
    Right Click 'pmdb$primavera'
    Choose >task > restore > Database
    Choose the correct backup location
    Go to 'Options'
    Under 'Restore Options' select 'Overwrite the existing database'
    Click OK for restore to start
     
    After restore - right click 'pmdb$primavera' & select 'new query'
     
    Copy & paste the below script & 'Execute'
     
    EXEC sp_change_users_login 'Update_One', 'pubuser', 'pubuser' 
    EXEC sp_change_users_login 'Update_One', 'privuser', 'privuser'
     
     
     
    After successful execution, start P6
    Report
  3. 0
    Muhammad Maisum ·
    #3

    hi i am facing the problem

    hi 
    i am facing the problem  regarding sql data base 
    i am using login 
    name:admin 
    password:admin
     but it gives this message
    >Unable to connect to the database.  Would you like to configure the database connection now?<
    when i try to configure database connection , it gives >database logon failed<
    i would appreciate any help
    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?