Hello,
I create a new Database from SQL Server Express 2014 and I would like to connect this Database with Knime.
So, I tried to use the DB connector but I have this error :
Execute failed: Selected JDBC driver does not support given JDBC url.
I’ve made a screen of the node configuration, maybe I did something wrong
Thank you for your help.
Hello @Stephane73,
The URL format for jTDS driver is:
jdbc:jtds:<server_type>://<server>[:<port>][/<database>][;<property>=<value>[;...]]
However I suggest to use dedicated node for connecting to SQL Server:
And for more info check this DB documentation guide:
Br,
Ivan
Hi @ipazin
Thank you for you’re solution. I tried to use the Microsoft SQL Server Connector like you’ve suggest.
But unfortunatelly it doesn’t work.
I have a very hard time with this connexion, I don’t know if I missed something with the configuration of the SQL Server.
It will be nice of you, if you can help me to resolve this issue.
Just for information, I am using SQL Server Express 2014. I have a old machine (32bits) with Windows 7, uprading to Windows 10.
Thank you.
Hello @Stephane73,
how does configuration of your Microsoft SQL Server Connector node looks like? What error did you get?
Br,
Ivan
Hello @ipazin
I have good news, I activated the TCP/IP from the configuration manager, then I restart the service and it finally worked.
Thank you
Thanks for the update. I have checked that as well. Get the same “generic” error message TCP “might be” the problem. Still not working for me. So far I rely on python but I guess that’s not comparable in terms of performance
Hello @Daniel_Weikert,
can you please open up a separate topic for you connection issue? Then we can properly address it and hopefully solve 
Br,
Ivan
Sure Ivan, sorry for that
bR
Hello @Daniel_Weikert,
don’t get me wrong, it’s not a problem you replying/commenting here as well. Only I have seen you did so in another topic and had one opened a year ago and still haven’t found a way to connect to your database. Considering you helped many users here seems appropriate to get proper help yourself
Br,
Ivan
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.
