Hi, I’m trying to establish a connection with SQL Server but I get this error, I’m not really clear what is the hostaname, if someone can explain me would be very helpful, thanks. [image]

Hi @slunah , did you check this specific post on @izaychik63 ’s links. [image] Problem connection to local SQL Server 2017 installation KNIME Analytics Platform Yes, well I didn’t even imagine the possibility that the server is not open for TCP/IP connections by default. netsat -an shows nobody is listening on 1433, so… Solution: Enable TCP/IP Connections in SQL Server Configuration [image] Hopefully someone saves some hours reading this smirk Odd though it seems, I suspect that your SQL server isn’t configured to listen for connections, and this needs to be switched on.

SQL Server to Knime Connection

KNIME Analytics Platform

izaychik63 October 25, 2022, 5:26pm 2

See if those links help with your issue

1 Like