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 Wednesday, February 13, 2008 3:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Thursday, April 24, 2008 1:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 17, 2008 3:52 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, November 02, 2008 8:03 PM
Points: 1, 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
Post #518629
Posted Wednesday, October 29, 2008 9:21 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, March 25, 2009 12:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 25, 2009 12:07 AM
Points: 1, Visits: 16
I have this problem
Post #683065
Posted Sunday, May 10, 2009 11:12 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, May 10, 2009 11:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, May 10, 2009 11:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 30, 2009 10:13 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Tuesday, June 30, 2009 10:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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 »

Add to briefcase 1234»»»

Permissions Expand / Collapse