P6 database connection

H
Hamish King 👤 Member for 22 years 4 months
H
Hamish King 👤 Member for 22 years 4 months

Thanks again Arnold.



I think you are right (it was installed in a rush...)



I have the password set at installation as I can use it to get into the database administrator. My guess is something went wrong with the database when my computer crashed. I left it with the IT chap this afternoon to see what he can do but it appears I know more about the software then he, so it does not bode well.



Might have to do a total reinstall :-(

A
Arnold Puy 👤 Member for 19 years 3 months

Hi Hamish,



If I am not mistaken you installed the Oracle XE (Oracle Express Edition). Well, the passwords for these users will be the password you provide during installation.



You must remember this password because it will be used as the password for all default database users created during installation.



Regards,



Arnold


H
Hamish King 👤 Member for 22 years 4 months

Wow - thanks for the immediate response.



I am given 3 database options:

ORAPMDB

ORAMMDB

Project Management_1



Using the pubuser log in gives me a different error message during configuration - "Bad public user name or password. Database Server Error: ORA-01017: invalid username/password; logon denied;"?



Any more thoughts?



Ta!

A
Arnold Puy 👤 Member for 19 years 3 months

Hi Hamish,



Welcome to Planning Planet.



If this a stand-alone installation try to configure your database using the following:



Host Name: COMPUTER_NAME\PRIMAVERA

Database name: PMDB$PRIMAVERA

Username: pubuser

Password: pubuser

Public group ID: 1



Otherwise, there is something wrong with your MSSQL. You need to install again.



Regards,



Arnold




Featured Partner

Top Posters

jeoffrey reyes
15 posts
Zine Eddine
2 posts
Alex Lyaschenko
27 posts
mxsiegel
0 posts
Mattvtek
0 posts
Gareth Evans
3 posts
PP Admin
3, 129 posts
Rajkamal Tangirala
5 posts
Rahul Kumar
1 posts
blake333_
0 posts