SQL Server to Knime Connection

[slunah]

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.

[izaychik63]

See if those links help with your issue

Knime to SQL Express with dynamic Port

Hi @mabm, Having looked around on the web, and after playing with my local SQL server, the ability to connect dynamically to SQL Server ports appears to be very much dependant on your SQL Server installation, and not KNIME (or any other db client). If you have dynamic port allocation on SQL Server, then there are two ways to achieve a connection. (1) Specify the currently assigned specific port number, by looking in the SQL Server Configuration Manager on the server [image] [image] and on…

Problem connection to local SQL Server 2017 installation

Hello everybody I am having a problem connecting to a local MSSQL Server instance: Microsoft SQL Server Developer (64-bit) 14.0.1000.169 KNIME 3.5.2 using the integrated Microsoft SQL Server Connector. I am using these connection settings: [Capture] Error: ERROR Microsoft SQL Server Connector 0:1 Execute failed: Could not create connection to database: Connection refused: connect The users are created on the sql server and working (tested with Management Studio). The SQL Server i…

[takbb]

@slunah

I’m not really clear what is the hostaname,

Hi @slunah , and welcome to the KNIME Community.

Hopefully the links that @izaychik63 had posted will be of assistance. To help answer your specific question, the hostname is either the computer name or IP address of the server where the SQL server database is running. If the database is running on the same machine that you have KNIME installed, you can generally use “localhost” or the IP address 127.0.0.1

If it is running on a remote server, you will need to use the network address (IP address) of that server machine.

[slunah]

@takbb

@slunah

I’m not really clear what is the hostaname,

Hi @slunah , and welcome to the KNIME Community. The hostname is either the computer name or IP address of the server where the SQL server database is running. If the database is running on the same machine that you have KNIME installed, you can generally use “localhost” or the IP address 127.0.0.1

If it is running on a remote server, you will need to use the network address (IP address) of that server machine.

Hi @takbb , I have tried with localhost and the IP address 127.0.0.1, I have TCP/IP enabled on the SQL Server but my error is still the same and the user and SA are correct and as far as I saw the port was 1433, I don’t understand what could be wrong.

[takbb]

Hi @slunah, did you check this specific post on @izaychik63’s links.

Problem connection to local SQL Server 2017 installation

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

Odd though it seems, I suspect that your SQL server isn’t configured to listen for connections, and this needs to be switched on.

[slunah]

@takbb

SQL no está configurado para escuchar conexione

Yes, indeed the listening port was not 1433 but 1434, thank you very much.
ii