We want to use our Azure SQL Server and connect it with Knime. Our server is in the cloud and not locally in desktop.
I use the Microsoft SQL Server Connector node in Knime, entering the correct host name, database details, credentials etc but I keep receiving the below error:
"The TCP/IP connection to the host database , port 1443 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.”
P.S I’m able to connect and work on the server with the same settings so the issue is only when I try to connect it with Knime.
I’ve found in other threads that I need to ensure TCP/IP is enabled in the SQL Service configuration manager, but as my server is on the cloud and not locally, I don’t have the option to do that.
I don’t use Azure, but for my remote server I was never able to get the Microsoft SQL server connector to work even with exactly the same setting.
At least for me connecting to a remote db server the “DB Connector” worked. in DB type you can select SQL Server and the driver I used was SQL server v7.2.0. The data base url I only put my server jdbc:sqlserver://Server address. But the key was to put the parameters in the JDBC Parameters section e.g. Instance name, database name integrated security.
Is there a connector for Azure db if above doesn’t work?