2 Replies Latest reply on Jan 7, 2011 10:21 PM by Barrie Callender

    P6 Web Access connection to MS SQL Server database using TCP Dynamic Ports


      I am attempting to install P6 Web Access. When I run the installation and do the database configuration I am required to input a port number into the Database Host Port field. I do this and no error is displayed graphically, but I get a connection refused error when I look in the web access log.

      "com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect "

      The dba is running the database on an sql server farm and does not want to apply a static tcp port to the Primavera database as this will interfere with his other databases.

      The fact that it appears to be mandatory to input a host database port during database configuration, has me thinking that P6 Web Access requires that the database be set up with a static TCP port? Is this correct?

      I searched the documentation about this but came away with nothing...

      any help would be truly appreciated.