Why do I get an error message indicating that the TCP/IP connection to the host has failed when connecting to a JDBC server using the Database Toolbox 3.5 (R2008b)?

I get an error message when connecting to a JDBC server using Database Toolbox 3.5 (R2008b). The error message is as follows:

 The TCP/IP connection to the host xxx.net, port 2611

 has failed. Error: "Connection refused. Verify the connection

 properties, check that an instance of SQL Server is running on the host

 and accepting TCP/IP connections at the port, and that no firewall is

 blocking TCP connections to the port.".

Answer 1

[MathWorks Support Team]

This is an expected behavior when connecting to a JDBC server using Database Toolbox 3.5 (R2008b). The possible reasons for this behavior are as follows:

1. The chosen port while installing the SQL Server might be already in use.

2. Permissions to the user name which is accessing the database might not have been granted.

3. If it a remote machine, remote settings are not enabled.

As a workaround, you can do the following:

Open SQL Server Configuration Manager -> Protocols for SQL SQLEXPRESS, select Properties of TCP/IP. In the tab IP Addresses, set the TCPPort in section IPAll to 1433.