P6 Database Configuration - Bad Private Username or Password
Hi Guys,
I am trying to configure P6 having already installed and have running EPPM. When I attempt to connect to the database using the pubuser and the correct password the login fails and asks to check public group id.
Users pubuser, privuser and pxrptuser are in the database as logins, users and have schemas. I have checked passwords.
Initially when trying to use pubuser/PW and public group ID=1 combo it returned the error saying login failed for privuser, not pubuser.
I then found the PUBUSER table and it initially only had one row, that being for privuser as group ID 1,and the password looking like it is encrypted. I added a row for pubuser as group ID 2 and the password as human readable. This allows the config tool to see pubuser but the it still doesn't connect.
I am trying to configure P6 having already installed and have running EPPM. When I attempt to connect to the database using the pubuser and the correct password the login fails and asks to check public group id.
Users pubuser, privuser and pxrptuser are in the database as logins, users and have schemas. I have checked passwords.
Initially when trying to use pubuser/PW and public group ID=1 combo it returned the error saying login failed for privuser, not pubuser.
I then found the PUBUSER table and it initially only had one row, that being for privuser as group ID 1,and the password looking like it is encrypted. I added a row for pubuser as group ID 2 and the password as human readable. This allows the config tool to see pubuser but the it still doesn't connect.
0