PMDB database configuration P6ver6.

S
Sunder Rao 👤 Member for 8 years 11 months

Muhammad,

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

Sunder

M
muhammad anwar 👤 Member for 19 years 5 months

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 2 months

Host Name?



On my computer it is,



RAVIRAJPC/PRIMAVERA


J
Janaki Ram Pithani 👤 Member for 19 years 9 months

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 9 months

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 2 months

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,

Featured Partner

Top Posters

Hamzah Ahmed
0 posts
Quinton van Eeden
3 posts
Sunchana Johnston
12 posts
Akram Hammam Mohamed
17 posts
Sagar Raut
14 posts
Patricio_aoa
0 posts
James Williams
75 posts
Philip Assou-Dodji
1 posts
jeoffrey reyes
15 posts
markg
0 posts