Knime connections - MS SQL SERVER Connection problem


I’m a bit frustating in using knime connections. With SQLITE and ORACLE it works very well. With Access I’m using the driver ucanaccess, this makes the connection but the connection itseld takes, long, long time. Don’t know why, even with connection with MS LABS it’s the same, but it works…

Diferent story is with MS SQL SERVER. I have to connect to diferent servers and I’m not able to connect to anyone. I’ve tried all the ways I know, the port node, the labs node, the Microsoft SQL SERVER CONECTOR, and nothing works.
I’ve installed the sqljdbc4.0 and the latest versions of it. Tried the string with instance and without, but nothing works.
From the server itself it has the TCP/IP configurations on.

I can access the server through ACCESS, EXCEL and Power BI and it works fine, so, what could be the problem?

I’m sending the log file, if anyone has an idea of how to connect, I would be very, very gratefull!

String the connection port:
jdbc:sqlserver://“I’m using IP”:1433;databaseName="*****";integratedSecurity=true;loginTimeout=30;

Execute failed: The TCP/IP connection to the host, port 1433 has failed. Error: “Connection refused: no further information. 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.”.

Not sure about your format. It should be
I mean no quotes.
Also, you may need to add User Name

Also, make sure that you’re using the correct JDBC jar for your SQL Server version (?) and the JRE version (we’re on Java 8).

( )

Yes, I’m using without quotes. The user and password I’ve define in the node, but also tried in the string, and didn’t work.

Hi there @ferraor,

have you managed to connect to SQL Server or still experiencing problems?


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.