database connection for primavera p6

  • okjagadeesh

    SSC Veteran

    Points: 259

    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

    SSC Enthusiast

    Points: 131

    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

    SSC Journeyman

    Points: 91

    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

    SSC Journeyman

    Points: 75

    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

    SSC Journeyman

    Points: 89

    I have this problem

  • pablo-1087167

    SSC Veteran

    Points: 271

    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

    SSC Veteran

    Points: 271

    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

    SSC Veteran

    Points: 271

    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

    SSC Veteran

    Points: 208

    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

    SSC Veteran

    Points: 208

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

  • kenankheops

    SSC Enthusiast

    Points: 106

    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 ?

    kenankheops@gmail.com

  • astrojar

    SSC Veteran

    Points: 261

    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

  • astrojar

    SSC Veteran

    Points: 261

    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

  • raja_remo007

    Valued Member

    Points: 61

    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

  • astrojar

    SSC Veteran

    Points: 261

    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