SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


database connection for primavera p6


database connection for primavera p6

Author
Message
okjagadeesh
okjagadeesh
SSC Rookie
SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)SSC Rookie (37 reputation)

Group: General Forum Members
Points: 37 Visits: 1
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
mailgoran
mailgoran
SSC Rookie
SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)SSC Rookie (49 reputation)

Group: General Forum Members
Points: 49 Visits: 1
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 ?
sulaiman.saeed
sulaiman.saeed
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 2
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
FZ1
FZ1
SSC Rookie
SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)SSC Rookie (29 reputation)

Group: General Forum Members
Points: 29 Visits: 1
i have this problem of connect P6 with SQL express

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

some has the solution to this problem

thank's
green2007
green2007
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 16
I have this problem
pablo-1087167
pablo-1087167
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 Visits: 1
While trying to configure the Database, I receive the following error.
Bad public user name or password. Databasse Server Error: Login Failed for user 'pubuser'?
How can I configure the database.
thanks
pablo-1087167
pablo-1087167
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 Visits: 1
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...
pablo-1087167
pablo-1087167
SSC-Enthusiastic
SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)SSC-Enthusiastic (101 reputation)

Group: General Forum Members
Points: 101 Visits: 1
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.
pskipton
pskipton
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 0
I followed your recomendation but it seems like i do not have the necesary permition (i am log in as an administrator). Is there another solution because it seemsl like i really can run P6
pskipton
pskipton
Valued Member
Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)Valued Member (68 reputation)

Group: General Forum Members
Points: 68 Visits: 0
I followed your recomendation but still i am not able to run P6, can you please help me out!!
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