I have setup a SQL server and I want to connect to it through KNIME. I used Microsoft SQL server Connection node but it gives me Login Timed Out error. I can access the server remotely through SQL Server Management Studio but not through KNIME.
It would really be great if any one can help on this.
Hi @mohini1329 , it would be useful to know if you are using windows authentication or sql server authentication, but I’m not sure if that will have an impact on what you are seeing.
Given it is a login timeout, and assuming you have the hostname configured correctly, I suspect it is more to do with having the correct port number configured.
Take a look at this thread. Unfortunately we never found out if it resolved the issue there, but might be worth checking…