P6 SQL database Configuration
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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.
[email protected]
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 [email protected]
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....[email protected]
this would be a great help.
thanks in advance
jorge
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
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
Yes, I got the solution for the Problem from one of the friend from planningplanet.
His name is :
Mr.Mmuhammad anwar
Heavy Civils
Thanks dear,
You did it for me, I was longing for this from quite a long time.