Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database connection for primavera p6


database connection for primavera p6

Author
Message
kenankheops
kenankheops
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 1
bonjour et bonne année 2010 ,
j'ai installé Primavera P6, mais cependant je n'arrive pas
à travailler dessus ,on me demande de configurer une
connexion à la base de donnée ,ne m'y connaissant pas en configuration
de base de données ,je suis bloqué.
help me please.

can you send me the screenshot ?

kenankheops@gmail.com
astrojar
astrojar
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 10
i installed successfully Primavera 6

1st ms sql server 2008
2nd primavera 6
3rd installed sql server 2005

DETAILS


Product : MSXML 6 Service Pack 2 (KB973686)
Product Version : 6.20.2003.0
Install : Failed
Error Number : 1603

Machine processor count: 1
OS version: Windows XP
OS service pack: Service Pack 3
OS architecture: x86
Process architecture: 32 Bit
OS clustered: No
Description: SQL Server Database Services 2008

ProductName: SQL2008
Type: RTM
Version: 10
SPLevel: 0

PROBLEM
Bad public user name or password. Database Server Error: SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ;

username: admin
password: admin
username: pubuser
database alias: PMDB

Please Help, Thanks!

Windows XP Pro v5.1 SP3
Primavera 6
MS SQL Server 2005
astrojar
astrojar
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 10
pablo-1087167 (5/10/2009)
I´ve found a solution in another forum, her it goes:


You will need to use the SQL Server Management Studio in order to get this to work. When you log into the SQL Manager, You select the P6 database. Right click and select: "New Query".

In the right pane you will need to paste the following script:

Exec sp_change_users_login 'Update_one','PUBUSER','PUBUSER'

Exec sp_change_users_login 'Update_one','PRIVUSER','PRIVUSER'

and select "Execute" from the menu. The connection to the priv- and pubuser is reastablished.

Now you will no longer receive the "Bad Public user name & password" error.

Grtz, inscore...


Hello,

I have the same problem, i have installed server 2008 and 2005, but i cant find the SQL Server Management Studio.

please help.
thanks

Windows XP Pro v5.1 SP3
Primavera 6
MS SQL Server 2005
raja_remo007
raja_remo007
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 0
sulaiman.saeed (6/17/2008)
mailgoran (4/24/2008)
When I try to log to Primavera P6 and put admin,admin I :

Bad public user name or password. Database Server Error: SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. ;

Do you have that problem ?
Do you solve that ?


I have the same problem. I downloaded v3 and v6 but same problem ANY HELP

astrojar
astrojar
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 10
pablo-1087167 (5/10/2009)
I´ve found a solution in another forum, her it goes:


You will need to use the SQL Server Management Studio in order to get this to work. When you log into the SQL Manager, You select the P6 database. Right click and select: "New Query".

In the right pane you will need to paste the following script:

Exec sp_change_users_login 'Update_one','PUBUSER','PUBUSER'

Exec sp_change_users_login 'Update_one','PRIVUSER','PRIVUSER'

and select "Execute" from the menu. The connection to the priv- and pubuser is reastablished.

Now you will no longer receive the "Bad Public user name & password" error.

Grtz, inscore...


hello, i followed this but same error occured and i have this message

Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 108
Terminating this procedure. The User name 'PUBUSER' is absent or invalid.
Msg 15291, Level 16, State 1, Procedure sp_change_users_login, Line 108
Terminating this procedure. The User name 'PRIVUSER' is absent or invalid.

Windows XP Pro v5.1 SP3
Primavera 6
MS SQL Server 2005
astrojar
astrojar
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 10
I have successfully installed Primavera 6 and SQL Server 2005.

I tried to remove and reinstall P6 again. without installing Sample Data and License. The license can be registered or used in Database Config.

Thanks again. More power!

Windows XP Pro v5.1 SP3
Primavera 6
MS SQL Server 2005
dan.airolink
dan.airolink
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 4
Error Install MS SQL Server Express in Windows XP SP3 / MSXML6 SP2

If you are trying to install Primavera P6 together with SQL Server 2005 Express edition in Windows SP3 environment, it will most likely fail unless Microsoft has done something to fix this. Read through this blog to find how to get around with this issue.

Symptoms include SQL Server Express edition installation return error and the error log mentioned MSXML 6 Service Pack 2 (KB954459) — Configuration failed. I am not really sure what the root cause is, but it looks like Windows XP SP3 or MSXML 6 Service Pack 2 protects the MSXML 6 configuration file from update and changes. As a result, the setup fail to continue.

There are some ways to solve this, including

Uninstall Service Pack 3, install Microsoft SQL Server Express edition, and reinstall SP3.
Disable the File system protection temporarily using regedit.

But, in my opinion the best way is: (I used this successfully)

Uninstall MSXML6 SP2, by using Windows Installer Cleanup Utility which can be downloaded from http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d5e1bd/msicuu2.exe.

After that, do a clean installation again of Primavera P6. It will also install successfully the SQL Express 2005. Install as Standalone also but now you can choose to install the sample projects and it will not cause problem.

Hope it will help.
sandanuwan
sandanuwan
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 0
pablo-1087167 (5/10/2009)
Still having trouble? Try this on windows vista 32bit:



1. Install P6 as a standalone.
2. Do not install sample Projects.

After installing reboot your PC. Try to login with User- admin Password- admin.
Then you will get message "Server not configured"
Now Start Here-
1. Click the tab beside database PMDB
2 You will see "Edit Database Connections"
3 Click Configure
4 Check Database alias= PMDB
5 Select Driver type = Microsoft SQL Server/SQL Express
6 Click Next and you will at Configure SQL Server Connection
7 Now here you should enter following -
Host Name = your computer name-PC\PRIMAVERA

(if you open My Computer you will find your computer name at bottomleft corner or open Device Manager your computer name will be at the top)

Database Name = pmdb$primavera

8 Go to next screen and Do not change anything!! , click Next to Validate database connection, 9

9 Go ahed by clicking Next, Check Connection Successful!! Dialog & Finish

Follow the same procedure for Methodology Management Database
Host Name will be the same
Database will be MMDB
Database name will be mmdb$primavera

Rest of all as above.


Wow! thank you very much for sharing this. It's helped me to get rid off huge trouble out of my brain. I registered with this forum just to say thank you! Smile
sandanuwan
sandanuwan
Forum Newbie
Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)Forum Newbie (6 reputation)

Group: General Forum Members
Points: 6 Visits: 0
okjagadeesh (2/13/2008)
sql server with pmdb$primavera database is running ok ,but connection with project management module is not establishing. not trusted server error coming. pl help to solve the problem



Configure SQL Server Connection as follows
Host Name = your computer name-PC\PRIMAVERA

Database Name = mmdb$primavera
astrojar
astrojar
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
Points: 15 Visits: 10
hi guys,

i have successfully installed primavera stand alone 6 and didnt installed sample project.

is there other way i can install the sample project?

please help
thanks

Windows XP Pro v5.1 SP3
Primavera 6
MS SQL Server 2005
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search