Hi Knimers,
while trying to get access to Microsoft SQL server, after entering host name , port , username and password in DB connector node and also choose “Microsoft SQL Server” for database Type I keep getting this error :
ERROR DB Connector 3:2727 Execute failed: Connection reset ClientConnectionId:cd903749-3ae7-454b-a98d-c8ea7b8cd583
any ideas??
Can you share more details on your set up?
There are several possible causes: In a corporate setting potentially IP Whitelisting: Is IP you are trying to connect from on that list?
TSL issue - also refer to this post:
Driver version… see this post:
Hello @MartinDDDD , thanks for quick response. I had a TSL issue and resolve it. About whitelisting, I have no idea how I can check that! could you kindly guide me on this matter?
That is indeed a bit tricky… can you connect from an computer to the DB successfully a different way? If so can you try with knime from that computer?
That`s a very good point @MartinDDDD , because I actually tried that; I installed Knime to the computer I want to connect ( where the SQL Microsoft is there!) and I got the same error! so it seems the problem is not the connection between my client computer and server! it should be something else !
ok so you can connect from a client (not via KNIME - via a different way) to the server, but from the same machine you can’t connect via KNIME…
I think then it might be proxy settings, but that’s something I am unfortunately not very familiar with … 
yeah many thanks @MartinDDDD though 