PMDB database configuration P6ver6.

Submitted by Janaki Ram Pithani on
Oracle Primavera - PM6

Member for

8 years 2 months
Member for 8 years 2 months
Submitted by sunderrao on Tue, 2017-08-15 09:33
Permalink

Muhammad,

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

Sunder

Member for

18 years 8 months
Member for 18 years 8 months
Submitted by muhammad anwar on Sun, 2010-02-21 19:14
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

Member for

19 years
Member for 19 years
Submitted by Janaki Ram Pithani on Sun, 2010-02-21 07:04
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

Member for

19 years
Member for 19 years
Submitted by Janaki Ram Pithani on Sun, 2010-02-21 03:07
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’.;

Member for

18 years 5 months
Member for 18 years 5 months
Submitted by A D on Sun, 2010-02-21 02:28
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,