Skip to content
ProjectControls.com
Oracle Primavera - PM6

Created New install of Primavera and SQL yet cant connect to it remotely

In the Open Standard
David TurtillMember for 9 years 8 months
Created
6
7
0

Hi all, 

 

we have a currently running version of P6 R8 that is failing so I have attempted to create a new one. 

 

I have created a new server and installed SQL 2016 express and configured this. I have then installed P6 on the server, and it can connect to it via the SQL method however if i try the same configuration on another machine i am getting the Prompt "Bad public user name or password. [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.;"

 

I have matched the TCP settings from the old setup to the new one and have refreshed the pub and priv users 

 

can anyone advise where I am going wrong, please. 

Save Follow Follow forum Report
Reply New topic

6 replies

Oldest first
  1. 0
    Zoltan Palffy ·
    #1

    the TCP setting will be

    the TCP setting will be specific for that machine

    got to start then type regedit 

    look under HKEY_LOCAL_MACHINE and expand it 

    scroll down to Microsoft SQL Server then to PRIMAVERA THEN TO MSSQLS then to SuperSocketNetLib then to TCP

    on the right look for the number under Data thats the TcpPort number you want to use. 

    Report
  2. 0
    David Turtill ·
    #2

    Thanks Checking this shows

    Thanks Checking this shows port 1433 which is what it is set as yet it still isn't working 

     

     

    sorry just to clarify it is working on the machine that has SQL installed and primavera but not when i try to connect from another machine 

    Report
  3. 0
    Zoltan Palffy ·
    #3

    the other machine must also

    the other machine must also have primavera. How are you connection to the machine that has sql on it ?

    Report
  4. 0
    Pratap Dinahar ·
    #4

    Try turning the firewall off

    Try turning the firewall off and then connecting. 

    Also check to see if you have the SQL Browser service running, that affects SQL connections sometimes. 

    If that doesn't work, try entering it in the format 'IP address\instance name' for the host name instead of the computer name. 

    Report
  5. 0
    David Turtill ·
    #5

    The other machine does have

    The other machine does have primavera on . and is working to SQL as it is how I connect to the current Primavera setup 

     

    starting the browser didn't work on its own but that and disabling the firewall did work will start trying to allow the port again 

     

    this is now working for the new database, however, if I import a database I am getting the bad username or password message 

     

     

    I have run Execsp_change_users_login 'Update_one','PUBUSER','PUBUSER'

    Execsp_change_users_login 'Update_one','PRIVUSER','PRIVUSER'

     

    however when originally set up it was done with the pub and priv users as pubuser1 privuser1

    Report
  6. 0
    Zoltan Palffy ·
    #6

    go with pubuser pubuser

    go with pubuser pubuser

    Report

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Log inJoin free

Existing members: your original username and password still work. Forgot password?