PMDB database configuration P6ver6.

Oracle Primavera - PM6
S
Sunder Rao 👤 Member for 8 years 10 months
· Permalink

Muhammad,

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

Sunder

M
muhammad anwar 👤 Member for 19 years 4 months
· Permalink

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
A D 👤 Member for 19 years
· Permalink

Host Name?



On my computer it is,



RAVIRAJPC/PRIMAVERA


J
Janaki Ram Pithani 👤 Member for 19 years 7 months
· Permalink

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

J
Janaki Ram Pithani 👤 Member for 19 years 7 months
· Permalink

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
A D 👤 Member for 19 years
· Permalink

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,

Forum Sponsor

Top Posters

Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts