Hi all,
Currently, i am facing issue with the reading of the database data to KNIME from Microsoft SQL Server Management Studio. Tried using “Microsoft SQL Server Connector” and “Database Reader” node but up to no avail, i am still facing error.
This is part of the Error Code that surface:
ERROR Microsoft SQL Server Connector 0:2 Execute failed: Could not create connection to database:
Hope to get assistance from u guys soon. Thank you.
If you can please provide your workflow. It could be some configuration issues that gives same error message.
Make sure you have installed Microsoft JDBC. I assume you have database account not Windows authentication.
Thank you for your reply. I do have a database account for the particular database however i am not the admin for the database, and i am only granted the permission to do (SELECT) from the database though.
The error message only states: Timeout error which is vague.
Could it be the issue with the hostname?
Try to increase driver timeout in menu.
File/Preferences/KNIME/Database.
Host name should be the same you use in the Management Studio.
After increasing the driver timeout.
The result:
ERROR Microsoft SQL Server Connector 0:2 Execute failed: Could not create connection to database: The TCP/IP connection to the host (HOSTNAME), port 1433 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.”.
I assume that would be the issue from the host database side.
Hi Izaychik63,
Thank you for your assistance. I’ve managed to resolve the issue and it was due to the PORT.
Cheers!
