MATLAB: 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)

connectiondatabaseDatabase Toolboxjdbc

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.".

Best Answer

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.
Related Question