database connection for primavera p6

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » database connection for primavera p6

33 posts, Page 1 of 4

1 2 3 4 »»»

database connection for primavera p6

Rate Topic

Display Mode

Topic Options

Author

Message

okjagadeesh

Posted Wednesday, February 13, 2008 3:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, April 25, 2008 10:00 PM
Points: 1, 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

Post #454943

mailgoran

Posted Thursday, April 24, 2008 1:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, April 24, 2008 2:22 PM
Points: 1, 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 ?

Post #490281

sulaiman.saeed

Posted Tuesday, June 17, 2008 3:52 PM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, November 02, 2008 8:03 PM
Points: 1, Visits: 2

mailgoran (4/24/2008)

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

Post #518629

FZ1

Posted Wednesday, October 29, 2008 9:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, October 30, 2008 3:43 AM
Points: 1, 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

Post #593698

green2007

Posted Wednesday, March 25, 2009 12:07 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, March 25, 2009 12:07 AM
Points: 1, Visits: 16

I have this problem

Post #683065

pablo-1087167

Posted Sunday, May 10, 2009 11:12 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 10, 2009 11:34 AM
Points: 3, 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

Post #713731

pablo-1087167

Posted Sunday, May 10, 2009 11:35 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 10, 2009 11:34 AM
Points: 3, 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...

Post #713737

pablo-1087167

Posted Sunday, May 10, 2009 11:40 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, May 10, 2009 11:34 AM
Points: 3, 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.

Post #713739

pskipton

Posted Tuesday, June 30, 2009 10:13 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 30, 2009 10:11 PM
Points: 2, 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

Post #745058

pskipton

Posted Tuesday, June 30, 2009 10:15 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 30, 2009 10:11 PM
Points: 2, Visits: 0

I followed your recomendation but still i am not able to run P6, can you please help me out!!

Post #745060

« Prev Topic | Next Topic »

33 posts, Page 1 of 4

1 2 3 4 »»»

Permissions