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 xx.xxx.xx.xx, 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.”.