P6 SQL database Configuration

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

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 

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.

Hi to all ,

i have same problem , please guide 

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

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 ;)

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

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

Hi Pundalik

So what was the solution please?

We are all waiting.

Best regards

Mike Testro

i have the same pb with Oracle database (oracle express in a stand alone mode), with the same symptom at the end, can anybody help me with this pb. i’ m not able to configure the database.



thanks in advance for your help