MS Sql Unknown Host

[datajunkie1000]

Hi All

I have a simple job which reads from a MS SQL 2016 database and logs the results. The job runs fine within Talend Studio but when I publish it to Talend Cloud I get an "unknown host" error. Has anyone seen a similar issue before?

The exception I'm getting is

tDBConnection_1 Unknown server host name '[SERVERNAME]'.java.sql.SQLException: Unknown server host name '[SERVERNAME]'. at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:427) at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at talendmssqltest.mssqlreadwritetest_0_1.MSSqlReadWriteTest.tDBConnection_1Process(MSSqlReadWriteTest.java:826) at talendmssqltest.mssqlreadwritetest_0_1.MSSqlReadWriteTest.runJobInTOS(MSSqlReadWriteTest.java:2402) at talendmssqltest.mssqlreadwritetest_0_1.MSSqlReadWriteTest.main(MSSqlReadWriteTest.java:2196)Caused by: java.net.UnknownHostException: [SERVERNAME] at java.net.AbstractPlainSocketImpl.connect(Unknown Source) at java.net.SocksSocketImpl.connect(Unknown Source) at java.net.Socket.connect(Unknown Source) at net.sourceforge.jtds.jdbc.SharedSocket.createSocketForJDBC3(SharedSocket.java:288) at net.sourceforge.jtds.jdbc.SharedSocket.(SharedSocket.java:251) at net.sourceforge.jtds.jdbc.JtdsConnection.(JtdsConnection.java:331

[Anonymous · Accepted solution]

Hi
If your DB is installed in local network, you need to install a remote engine and select this remote engine instead of Cloud as Runtime engine to run the task.
About installing Talend Remote Engine, please read this documentation page:
https://help.talend.com/reader/NkKh400tF3Z4O8jjJ23uUQ/kKXQi_BDUvY9L7FA9QcdQQ

Regards
Shong