Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««1234»»»

database connection for primavera p6 Expand / Collapse
Author
Message
Posted Sunday, January 17, 2010 6:47 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 17, 2010 7:52 PM
Points: 2, 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
Post #848928
Posted Wednesday, May 19, 2010 5:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 5:03 AM
Points: 5, 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
Post #924196
Posted Wednesday, May 19, 2010 9:54 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 5:03 AM
Points: 5, 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
Post #924431
Posted Friday, May 21, 2010 7:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, May 21, 2010 7:45 AM
Points: 1, 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
Post #925958
Posted Monday, May 24, 2010 9:47 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 5:03 AM
Points: 5, 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
Post #926932
Posted Monday, May 24, 2010 11:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 5:03 AM
Points: 5, 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
Post #926983
Posted Wednesday, June 16, 2010 6:50 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 12, 2011 10:32 AM
Points: 1, 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.
Post #938126
Posted Thursday, June 24, 2010 1:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 1:47 AM
Points: 2, 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! :)
Post #942279
Posted Thursday, June 24, 2010 2:01 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 1:47 AM
Points: 2, 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

Post #942287
Posted Thursday, June 24, 2010 5:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, June 24, 2010 5:03 AM
Points: 5, 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
Post #942361
« Prev Topic | Next Topic »

Add to briefcase ««1234»»»

Permissions Expand / Collapse