Verify the server and instance names and check that no firewall is running on the host.

KNIME Analytics Platform
1

Hi ,

I'm trying to connect the MS SQL database with Knime and i'm getting the error 

 

ERROR     Database Reader                    Execute failed: com.microsoft.sqlserver.jdbc.SQLServerException: The connection to the host user121, named instance \sqlexpress failed. Error: "java.net.SocketTimeoutException: Receive timed out". Verify the server and instance names and check that no firewall is blocking UDP traffic to port 1434.  For SQL Server 2005 or later, verify that the SQL Server Browser Service is running on the host.

 

Is there a solution for this.

 

I have updated the new driver and configured TCP from SQL Server configuration manager too.

The SQL server browsing service is enabled too. 

The UDP port number 1434 is also added to the firewall.

Thanks

 

2

Hi,

this seems to be a network problem. Have you tryed to ping the db server from the machine you are runing KNIME on or checked that the port is open for example via telnet?

Bye,

Tobias