Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

P3e v5 compatibility with SQL Server 2005

14 replies [Last post]
Wed, 2007-02-07 04:03
Michael Hunter
User offline. Last seen 16 years 1 week ago. Offline
Joined: 7 Feb 2007
Posts: 10
Groups: Petro-Chem / Oil & Gas
Has anyone out there installed Primavera Enterprise v5 on a server running SQL Server 2005?

I know its not on the "tested" list from Primavera but I can’t wait until v6 is released. It would be neat if I could install P3e v5 on the existing IT infrastructure rather than erect a separate box with SQL Server 2000 [if the the IT folk would let me ;-) ].

Thanks
Michael
Top

Replies

Sun, 2007-03-25 05:12
#1
mimoune djouallah
User offline. Last seen 5 years 2 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
hi ruben

fine, ok it is developper edition, don’t ask me which sp, cause i don’t know, a friend who install it, we did not get enough time to test it, if it works with p5 in a client server fashion, because he know that he will be fired, fuc....; job cut.

mimoune
Top
Fri, 2007-03-23 08:02
#2
ruben quintal
User offline. Last seen 16 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 33
Groups: None
hi mimoune,

SQL2000 database server (enterprise edition) cannot be installed in windows xp sp2. the server must be installed in windows 2000 or windows 2003. what sql2000 edition did you used?

ben
Top
Wed, 2007-03-14 10:42
#3
mimoune djouallah
User offline. Last seen 5 years 2 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
ruben

all you need is windows xp sp2, with administrator right if you don’t have a lot of projects, MSDE can very well handle the job.

just an advise if you have a problem installing primavera just post your questions in primavera installation help.

friendly
Top
Wed, 2007-03-14 10:23
#4
ruben quintal
User offline. Last seen 16 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 33
Groups: None
i cant install it, i tried many times. wat version of xp are you using? i tnk i need to consult the it guy for this.
tnx anyway.

cheers,
ben
Top
Wed, 2007-03-14 09:45
#5
mimoune djouallah
User offline. Last seen 5 years 2 weeks ago. Offline
Joined: 14 Oct 2006
Posts: 388
Groups: Petro-Chem / Oil & Gas, Spider Project Team
ruben

Who told you that, SQL 2000 of course is supported on windows xp, actually the default database bundled with primavera 5 (used in stand alone installation mode) is a light version of SQL server 2k

Friendly
Top
Wed, 2007-03-14 09:28
#6
ruben quintal
User offline. Last seen 16 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 33
Groups: None
tnx michel,
the problem is that our system is using windows xp which does not support SQL 2k, so i need to install the database without using SQL 2k.

Hope someone can help me.

Tnx.
Ben
Top
Fri, 2007-03-09 19:15
#7
Michel Molenaar
User offline. Last seen 17 years 20 weeks ago. Offline
Joined: 1 Jul 2004
Posts: 6
Groups: None
I like this tread .. you are on the right path. However, it should be pointed out that Primavera Systems, Inc. does not support Primavera 5.0 on SQL Server 2005. So this whole discussion should not even take place .. :) ..

However, since it’s already on the way .. :) ... by all means go on ...

Another (perhaps easier) solution would be install SQL 2k next to SQL 2005. It is possible and officially supported by Microsoft.

Greetz,

Michel Molenaar

Top
Mon, 2007-03-05 10:19
#8
ruben quintal
User offline. Last seen 16 years 32 weeks ago. Offline
Joined: 26 Sep 2006
Posts: 33
Groups: None
Vu Dang,

I have followed your instruction step by step and my Methodology Management Module is now working properly with SQL 2005 but the PM just starts loading and after a while, a note pop out which says "an unhandled exception occur in PM. exe (3204)".
Can you pls give me some advice.

ben
Top
Wed, 2007-02-28 05:26
#9
Chris Bartley
User offline. Last seen 17 years 18 weeks ago. Offline
Joined: 13 Feb 2007
Posts: 5
Groups: None
Thanks Vu Dang.

That gets me a lot further than I was.

Now, I can set up the database connection for PM successfully.

Then I start PM, logging in using user admin / pwd admin. Yay! It starts loading the database (with the usual progress bar). But then, after the progress bar reaches 100%, I get the windows XP error ’Primavera Project Manager has encountered a problem and needs to close. We are sorry for the inconvenience.’ etc

This seems to be a dead end. The database connection is working, the login to PM is working, the data starts loading, and then BLAM it’s all over rover. I wonder what the difference with your system is, since you have sql express 2005 working??

Cheers,

Chris
Top
Wed, 2007-02-28 05:08
#10
DANG CORP
User offline. Last seen 8 years 46 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
Hi Chris,

In replies to your Priv Msg.
===============
Here is a more details steps.

from your email, it seems that you are 90% there.

here is the final steps.

1. log into your sql 2005 express management console.
2. recreate the two user again. privuser and pubuser. the password is same as login ok! (i think you have already created this)
3. now click the "NEW QUERY" button. and paste this line in.

4.
use The_Name_Of_Your_Database_Matey
EXEC sp_change_users_login ’Update_One’, ’PUBUSER’,’PUBUSER’
EXEC sp_change_users_login ’Update_One’, ’PRIVUSER’,’PRIVUSER’
GO

5. now try and login to your Project management.

Kind regards,

Vu Dang
www.dangcorp.com





Vu Dang,

I read with interest your post on using sql express 2005 with primavera. I have one question: what are the default passwords for pubuser & privuser? I think I need to have added these to the sql server before attaching the PMDB database.

Kind regards,

Chris Bartley
Top
Tue, 2007-02-13 00:39
#11
Chris Bartley
User offline. Last seen 17 years 18 weeks ago. Offline
Joined: 13 Feb 2007
Posts: 5
Groups: None
sorry, step 2 should read that i uninstalled sql server 2000 (not 2005)
Top
Tue, 2007-02-13 00:37
#12
Chris Bartley
User offline. Last seen 17 years 18 weeks ago. Offline
Joined: 13 Feb 2007
Posts: 5
Groups: None
Vu Dang,

I am trying to get P5 working with SQL 2005. The steps I followed were:
1. I detached the data file (pmdb_dat.mdf/ldf) from the previous SQL Server 2000.
2. I uninstalled SQL server 2005.
3. I installed SQL server 2005 (express)
4. I created the users privuser and pubuser (passwords privuser / pubuser respectively)
5. I copied pmdb_dat.mdf/ldf into the MSSQL\Data folder for the new installation, and attached it in SQL 2005 via the management studio.

So far, so good. It appears in SQL 2005 and is accessible.

BUT, even I cannot assign privuser\pubuser logins to the PMDB database (using User Mapping). It says that the ’user, group or role ’privuser’ already exists in the current database’.

Any ideas how to hook up these logins??

cheers,

chris
Top
Wed, 2007-02-07 18:50
#13
Michael Hunter
User offline. Last seen 16 years 1 week ago. Offline
Joined: 7 Feb 2007
Posts: 10
Groups: Petro-Chem / Oil & Gas
Vu Dang

Thank you for your response; today I am happy!

I will try your steps on Monday and see if that works.

Regards
Michael
Top
Wed, 2007-02-07 10:24
#14
DANG CORP
User offline. Last seen 8 years 46 weeks ago. Offline
Joined: 3 Oct 2004
Posts: 71
Groups: None
Hi Michael,

Yes, you can run it on sql server 2005

steps
---------
- install it as standalone first!
- use your 2005 sql admin console and connect to the standalone database (you know the localhost\primavera)
- then restore it back into your sql 2005.

remember to create privuser and pubuser first in your sql 2005 (you got to do this manually).

Vu Dang
www.dangcorp.com
Top