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...
At my previous company we experienced a similar issue with P6 Web. Our P6 database was hosted on an Oracle RAC and when configuring the Web connection I was forced to point it to a single RAC server rather then allow it to utilize the cluster. If you have found a resolution to this I would be interested in hearing about it.
The port number you are entering should be the correct one for connecting to your database. Your DBA should be able to tell you what it is. I imagine you are using the default 1433 and it is very unlikely to be set to that.