This discussion is archived
2 Replies Latest reply: Jan 7, 2011 2:21 PM by barrie RSS

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

806695 Newbie
Currently Being Moderated
Hi,

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.

Andy

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points