P6 Unable to configure SQL Database after Computer Crash

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.

M
muhammad maisum 👤 Member for 12 years 10 months
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
D
Dewald de Vlamingh 👤 Member for 14 years

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
F
Forest Peterson 👤 Member for 15 years 2 months

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)

Forum Sponsor

Top Posters

Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts