Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

PMDB database configuration P6ver6.

7 replies [Last post]
Janaki Ram Pithani
User offline. Last seen 8 years 19 weeks ago. Offline
Joined: 19 Oct 2006
Posts: 7
Groups: None
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

Replies

Sunder Rao
User offline. Last seen 6 years 32 weeks ago. Offline
Joined: 14 Aug 2017
Posts: 2
Groups: None

Muhammad,

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

Sunder

muhammad anwar
User offline. Last seen 3 years 37 weeks ago. Offline
Joined: 5 Feb 2007
Posts: 46
Groups: TILOS
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
A D
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Host Name?

On my computer it is,

RAVIRAJPC/PRIMAVERA

Janaki Ram Pithani
User offline. Last seen 8 years 19 weeks ago. Offline
Joined: 19 Oct 2006
Posts: 7
Groups: None
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
Samer Zawaydeh
User offline. Last seen 5 years 4 weeks ago. Offline
Joined: 3 Aug 2008
Posts: 1664
Dear J,

Try:

Username: admin
Password: admin

Good luck,

Samer
Janaki Ram Pithani
User offline. Last seen 8 years 19 weeks ago. Offline
Joined: 19 Oct 2006
Posts: 7
Groups: None
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’.;
A D
User offline. Last seen 3 years 20 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
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,