Tuesday, September 07, 2010
 Search
Forum » PM Software » New Primavera » P6 & MS SQL Server. Need help.

Get free P3, P6, Project tips & tricks, register to
our newsletter!

To be able to post message in forums, please login or register.

Registration is free (also spam-free)!

Unanswered Active Topics ForumsSearch Members
P6 & MS SQL Server. Need help.
Last Post 03 Sep 2010 02:21 PM byAyo Ayo. 85 Replies.
AddThis - Bookmarking and Sharing ButtonPrinter Friendly
Sort:
PrevPrev NextNext
Add ReplyAdd Reply
Page 1 of 512345 > >>
AuthorMessages
MustafaUser is Offline
New Member
New Member
Send Private Message
Posts:3
Mustafa

--
20 Jun 2008 06:50 AM QuoteQuoteReplyReply  
Please help, Installed P6 and MS SQL Server 5. In SQL Server created database, user and assigned all necessary rights. Enabled all network protocols. When launching P6 it requires Database Configuration to be completed first. Have difficulties with Database Configuration Wizard - have no idea what the following fields mean: Database Alias and Public Group ID. Using defaults for these two values gives an error: "Bad private user name or password. Check the public group ID. Database Server Error: Invalid object name ’PUBUSER’." Please advice. Thanking you in advance. Mustafa
msalUser is Offline
New Member
New Member
Send Private Message
Posts:1
msal

--
20 Jun 2008 08:17 AM QuoteQuoteReplyReply  

I got similar problem, after re-installing P5

Bad login name for SQL server,

and I looked in SQL forums but did not get it.

i will appreciate if any can  help

ammad (guest)
Posts:386
ammad (guest)

--
20 Jun 2008 01:42 PM QuoteQuoteReplyReply  
Hi,
can you please give me link of Primavera 5/6 software or turorual. i will be greatful

Thaks
Ahmet CetinUser is Offline
Senior Member
Senior Member
Send Private Message
Posts:289
Ahmet Cetin

--
21 Jun 2008 12:04 AM QuoteQuoteReplyReply  

Hello Mustafa,
If I understand right, you've created database manually. First of all, if you will use P6 on desktop in a single user environment, I suggest to install it in Stand Alone mode.If you use it in multi user environment, then first install the database using Primavera setup. You shall create database manually only if you need to use unicode characters.

Ammad,
It is not possible to share copyrighted material here. For tutorial, you can find a getting started tutorial here under Workshops:

http://www.primaveratools.com/Works...fault.aspx

Cheers,

Ahmet Cetin

Muzzy14 (guest)
Posts:386
Muzzy14 (guest)

--
24 Jun 2008 02:32 PM QuoteQuoteReplyReply  

Teshekkurler Ahmet,

It does work, finally. But I've got different problem now, when I am starting p6, it asks me for a "Login Name" & "Password". Is there any template password? 
Does anyone else has got the same problem? 

Sorry for bothering you again.
Have a good day

Mustafa 

Ahmet CetinUser is Offline
Senior Member
Senior Member
Send Private Message
Posts:289
Ahmet Cetin

--
24 Jun 2008 02:47 PM QuoteQuoteReplyReply  
Hello Mustafa,

The default user name & password in Primavera is admin / admin. Password is case-sensitive. User name is not.

Cheers,

Ahmet Cetin
MustafaUser is Offline
New Member
New Member
Send Private Message
Posts:3
Mustafa

--
25 Jun 2008 07:24 AM QuoteQuoteReplyReply  
Hi Ahmet,

Thank you for your help. It works now.

Regards,

Mustafa
ranu_136 (guest)
Posts:386
ranu_136 (guest)

--
23 Aug 2008 12:28 PM QuoteQuoteReplyReply  
 Can i install P6 on vista

i am trying it on my lapto but can not get success for this and error is coming while configuring data base.
ArnoldUser is Offline
New Member
New Member
Send Private Message
Posts:8
Arnold

--
25 Aug 2008 02:39 PM QuoteQuoteReplyReply  
Yes, you can install P6 in Vista.
inscoreUser is Offline
Basic Member
Basic Member
Send Private Message
Posts:10
inscore

--
24 Oct 2008 12:42 AM QuoteQuoteReplyReply  

Mustafa,

I've just replied an earlier problem with the same issue.

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...

magjistari
Posts:386
magjistari

--
30 Dec 2008 03:53 AM QuoteQuoteReplyReply  
Still doesnt work for me. I installed it step by step as explained by Mr. Ahmet, as stand alone and it installed Microsoft SQL server menagement studio express. Next according to Mr. Inscore i try for new query and paste the exec.... but when i click on execute it answers that user doesnt have permission to perform this action. Whenever i try to open primavera 6 it first asks for username and password, once i write them down and click ok it shows that : "Unable to connect to the database. Would you like to configure the database connection now?" I get there and step by step i end up to the Host name and database name which i dont know and whatever i put in the result is bad public user name or password. Any ideas? Thanks a lot for your answers.
ATILLA
Posts:386
ATILLA

--
30 Dec 2008 10:44 AM QuoteQuoteReplyReply  
Mustafa,

If you installed SQL server manually, it means that SQL server made a connection default so you have to uninstall from control panel and then delete its folder in my documents manually. While you will try to install P6, automatic installtion wizard will be creating a SQL express by itself. P6 is not working with SQL 2005 which was installed manually.

On the other hand if I were you I would check language setups from control panel all options must be englısh (USA) and location USA... I have just solved a similar problem on my software with this way....

Cheers,

Atilla
MoizUser is Offline
New Member
New Member
Send Private Message
Posts:3
Moiz

--
31 Dec 2008 11:39 AM QuoteQuoteReplyReply  
i am installing primavera 6 standalone.. and getting this msg on sql server 2005 intallation

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

The installer has encountered an unexpected error. The error code is 2331. Error loading library C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\Bin\{B0F9497C-52B4-4686-8E73-74D866BBDF59}sqlca.dll or finding entry point The specified module could not be found.
.

For help, click: http://go.microsoft.com/fwlink?Link...tion%40x7e

------------------------------
BUTTONS:

OK
------------------------------


help plz........ i cant use primavera on windows vista ultimate......
cmsbplUser is Offline
New Member
New Member
Send Private Message
Posts:1
cmsbpl

--
15 Jan 2009 03:36 PM QuoteQuoteReplyReply  
I have installed P6 stand alone getting this message after login in.

Bad public user name or password. Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [2]. ;
AlexandreUser is Offline
New Member
New Member
Send Private Message
Posts:1
Alexandre

--
15 Jan 2009 06:57 PM QuoteQuoteReplyReply  
I would like to know why to install P6 with database PMDB and MMDB
Please answer step by step how create database manually.

Tank you

Alexandre from Brazil
eardicUser is Offline
New Member
New Member
Send Private Message
Posts:3
eardic

--
15 Jan 2009 08:21 PM QuoteQuoteReplyReply  
Hi cmsbpl,

Copy the P6 installation DVD content to hard drive and try run setup there.
That has worked fine with me when I got the same error message. Hope it will help you too.

Regards
Emre
kika
Posts:386
kika

--
23 Feb 2009 04:50 PM QuoteQuoteReplyReply  
i`ve been developing Integrated Project Control System (IPCS)
i use P6,MS SQL SERVER 2000 as database and PHP as interface..

i would like to know how to connect them,,
thank u
Jasbinder
Posts:386
Jasbinder

--
02 Mar 2009 11:42 AM QuoteQuoteReplyReply  
i am not able to instal P5 and P6 on my laptop which is having windows vista home premium. can you please suggest how i can install prima vera on windows vista
Rakesh
Posts:386
Rakesh

--
06 Mar 2009 09:49 AM QuoteQuoteReplyReply  
Bad public user name or password. Database Server Error: Named Pipes Provider: Could not open a connection to SQL Server [2].
tamer
Posts:386
tamer

--
12 Apr 2009 03:49 PM QuoteQuoteReplyReply  
the same problem i still facing
Add ReplyAdd Reply
Page 1 of 512345 > >>

Forums > PM Software > New Primavera

Quick Reply
toggle
 Username:
Subject:
Body:
Security Code:
CAPTCHA image
Enter the code shown above in the box below

Submit
Active Forums 4.2
Terms Privacy Statement
Copyright ©2010 Copyright 2007 by PrimaveraTools.com