P6 SQL database Configuration

Hi Pundalik

So what was the solution please?

We are all waiting.

Best regards

Mike Testro

Can anyone assist as I am having the same problem and have tried various workarounds that I have seen in this forum on the web?

Much appreciated

dear mr tilve,

could you pls. send me the solution...my email is....jic077c18@yahoo.com

this would be a great help.

thanks in advance

jorge

The thing is that you are unable to access to your Database. You have to reach your standalone Servor.  PM also instal a servor during the PM software installing.

That's not the end because depending on which version you have installed, P6V7 or P6.2.1 or previous version, PM instal different Servor. Indeed whith the P6V7 package Oracle provide by default the Oracle XE servor (which is a big shit impossible to manage), at the opposite with P6.2.1 and previous MSSQL Express 2005 is provided, and this one is manageable.

1- Connect to your Servor;

2- Reach you DB;

3- Check the users avaibles into this DB (Security/Users by memory) you should have Privuser & Pubuser;

4- Launch the following script (it works into MSSQl):

              exec sp_change_users_login 'update_one', 'pubuser', 'pubuser'
              exec sp_change_users_login 'update_one', 'privuser', 'privuser'

5- Launch PM and create a new connection alias;

6- Into the DB Config: Specify the password to reach the Servor, Enter the login & Password pubuser/pubuser or privuser/privuser.

It should work,

Good Luck ;)

HI TO ALL, I INSTALLED COMPLETELY AND SUCCESSFULLY A P6 IN MY LAPTOP, WINDOWS 7 , WHEN I ATTEMPTING TO LOG IN A MESSAGE APPEAR AS EXACTLY AS THIS "Unable to connect to the Database, would you like to configure it?" BUT WHEN I CONFIGURE STILL CANNOT LOG IN AND A MESSAGE AGAIN APPEAR AS EXACTLY AS THIS "Bad public user name or password. Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [53]. ".
CAN ANYBODY HELP ME? THANKS AND ADVANCE.can also send to my email engr.ayoub@hotmail.com

Hi to all ,

i have same problem , please guide 

i have tried but it is not going to solve , please guide how to fix the same issue.

i have tried but it is not going to solve , please guide how to fix the same issue.

sent solution via email 

Hi, I am having the same problem with Pundalik Tilve. Can anyone send me a solution via email.

markpaolo.mission@yahoo.com

much thanks 

sent solution via email but box wanted me ot sign up. I dont need to sign up for anything else