Hello, I’m trying to connect to a MS SQL Server database with a KNIME connector. I use the driver named Official Driver for Microsoft SQL Server v. 9.4.0. When I hit execute, after few seconds of working I receive this error in Console: ERROR Microsoft SQL Server Connector 3:4 Execute failed: The TCP/IP connection to the host 192.168.0.40, port 1433 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.”.
It doesn’t matter if I:
provide login credentials in this node or with credentials node
use the driver mentioned above or v. 7.2.0, which I believe was installed with KNIME.
I use vpn to connect to this db.
When I use the same credentials and details, on the same vpn in DBeaver (app for SQL queries), there are no issues and I can connect.
What might be the cause and solution for this? This is really frustrating, because on Friday I’m supposed to show how cool KNIME is to some people at my new work and without this connection working - it would be very hard.
No sure if this is your case but I encounter something similar when I used a personal VPN. A working KNIME connector stopped running. The reason is that the cloud never seen a connections from my new IP address range. Tried to connect from MSSMS and been asked to add the IP range to trusted connections. After that the connector in KNIME worked again. Not sure how DBeaver works though.
I would try to connect from MSSMS.
Assuming the above does not apply to you, could you share your Preferences/Knime/Databases window and the failing KNIME connector configuration screenshots please?
Trying to compare with mine…
Hi, I’m able to connect with MSSMS ot this database, however I cannot connect with KNIME.
I have no additional drivers installed, so there is no point in showing my Preferences → Knime → Databases window. However: this is my failing connector configuration.
The error message is still: ERROR Microsoft SQL Server Connector 3:6 Execute failed: The TCP/IP connection to the host 192.168.0.40, port 1433 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.”.
what is with the "" in the server definition. You should have a host address there, nothing else. I would remove the slash and anything after that and try again. I believe that the server is incorrect and the error says just that, I cannot server it may be behind a firewall.
Just for my clarification: you said you’re using a VPN. Is that company’s (are you logging in remotely) or it is yours. I got the similar error when I had to go through both.
I removed the backslash and it did not help. I have the same error message.
This is my company’s VPN, I use it to connect remotely. And there is no issue when I connect with this db and credentials with MSSMS, DBeaver or Power Query. Here’s the snapshot of conenction config for DBeaver. as you see - it also has the part after backslash and it connects to a proper db.
Sorry not an expert and don’t know your environment.
Our problem is that KNIME does not see the SQL Server (192.168.0.40).
Are you running KNIME from your local machine (Analytics Platform) or from a KNIME server?
If from a server it may be that the SQL server is not accessible from where your KNIME executor is running while your working connections are from the local machine.
This is KNIME Analytics Platform on my local machine. From the same machine with other apps, like MSSMS, I can connect to this server. With KNIME on this machine I can connect with other servers, also running Microsoft SQL Server. But this server and KNIME just don’t seem to work together.
Not sure how @Daniel_Weikert is connecting SQL Server using scripts.
My guess would be that he’s using a Java or Python snippet.
Just looked up how to connect Python to SQL Server and found this:
You can put the code into a Python snippet and get the result of the SQL in a table.
That’s if you have already Python installed and added to KNIME otherwise it will take you some time.
Been using both Java and Python Snippet Nodes but not to connect to databases.