SQL Server with dynamic TCP port

Situation:

 We were trying to create new database connection to a SQL Server from Adeptia.

Source SQL Server is configures with dynamic TCP port at its end and we only have read only access to that SQL Server.

So when trying to create connection we are receiving following error.

Connection could not be established. Either database connection properties are incorrect or database is down. Try again with correct properties.
Driver =com.microsoft.sqlserver.jdbc.SQLServerDriver$sqljdbc4.jar
URL = jdbc:sqlserver://test.company.net\testinstance:59797;DatabaseName=testDB
User ID = sa
Database connection failed to URL :jdbc:sqlserver://test.company.net\testinstance:59797;DatabaseName=testDB, Error : The TCP/IP connection to the host test.company.net, port 59797 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

Solution:

Since your SQL server is set up for a dynamic TCP port, defining a port in the connection string will cause an issue. Remove the port number from the connection string.