Troubleshooting a DBTuna agent which fails to connect to SQL Server
The DBTuna agent will connect to SQL Server via JDBC (Java Database Connectivity), which works over a TCP/IP protocol. In order for your DBTuna Agent to connect you must have the following pre-requisites:
1. Your SQL Server must have TCP/IP protocol enabled
2. You must enter the port number of the SQL Server listener port (the default is 1433)
3. Network connectivity must exist between your DBTuna machine and the SQL Server machine i.e. check for Firewall blocking etc.
Troubleshooting Errors:
Unable to establish a connection. com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host has failed. java.net.ConnectException: Connection refused: connect
This error usually points to an incorrectly entered listener port number, or TCP/IP disabled on the monitored SQL Server.
REQUEST A DEMO
START A FREE TRIAL