February 13, 2008 at 3:57 am
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
April 24, 2008 at 1:52 pm
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 ?
June 17, 2008 at 3:52 pm
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
October 29, 2008 at 9:21 am
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
March 25, 2009 at 12:07 am
I have this problem
May 10, 2009 at 11:12 am
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
May 10, 2009 at 11:35 am
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...
May 10, 2009 at 11:40 am
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.
June 30, 2009 at 10:13 pm
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
June 30, 2009 at 10:15 pm
I followed your recomendation but still i am not able to run P6, can you please help me out!!
January 17, 2010 at 6:47 pm
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 ?
May 19, 2010 at 5:40 am
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
May 19, 2010 at 9:54 am
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
May 21, 2010 at 7:45 am
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
May 24, 2010 at 9:47 am
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
Viewing 15 posts - 1 through 15 (of 36 total)
You must be logged in to reply to this topic. Login to reply