Scheduled task's TCP/IP connection failed when running from Talend Management Console

[Anonymous]

I am trying to run scheduled task from Talend Cloud Management Console. 

However I am experiencing the following error.

tDBConnection_1 The TCP/IP connection to the host VR-PC418, port 1433 has failed. Error: "VR-PC418. 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."

Full error

Spoiler

tDBConnection_1 The TCP/IP connection to the host VR-PC418, port 1433 has failed. Error: "VR-PC418. 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.". com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host VR-PC418, port 1433 has failed. Error: "VR-PC418. 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.".  at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:191)  at com.microsoft.sqlserver.jdbc.SQLServerException.ConvertConnectExceptionToSQLServerException(SQLServerException.java:242)  at com.microsoft.sqlserver.jdbc.SocketFinder.findSocket(IOBuffer.java:2369)  at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:551)  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1963)  at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:1628)  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectInternal(SQLServerConnection.java:1459)  at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:773)  at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:1168)  at java.sql.DriverManager.getConnection(DriverManager.java:664)  at java.sql.DriverManager.getConnection(DriverManager.java:247)  at backup_0409.db_migration_copy_table_0_1.DB_Migration_Copy_Table.tDBConnection_1Process(DB_Migration_Copy_Table.java:903)  at backup_0409.db_migration_copy_table_0_1.DB_Migration_Copy_Table.tPrejob_1Process(DB_Migration_Copy_Table.java:717)  at backup_0409.db_migration_copy_table_0_1.DB_Migration_Copy_Table.runJobInTOS(DB_Migration_Copy_Table.java:5081)  at backup_0409.db_migration_copy_table_0_1.DB_Migration_Copy_Table.main(DB_Migration_Copy_Table.java:4830)

I have enabled TCP/IP protocol from the start, so I have no idea why the error occurred.

Here's my setting,, I didn't have IPs enabled though... is it needed?
Please let me know how I can make it work.

Here's my management console's task page

Here's the job design

Please let me know if anything is unclear.

Thank you

[manodwhb · Accepted solution]

Check the below link has same case.
https://community.talend.com/t5/Design-and-Development/Job-failed-when-run-with-remote-engine/td-p/2...

[Anonymous]

@manodwhb 

I checked the link before, but it's the case when using remote engine right?

In my case, the job work well in Talend Studio, but not from Taland Management Console.

My data source is a SQL Server, which I setup a connection in Management Console, so I thought I don't need remote engine?

Job Design

Have the connection setup

[JohnRMK]

Good evening,

you are running your job in talend's default cloud engine.
How do you want it to connect to a local database?
Either you create a remote engine in server that had access to your databases or use a database in the cloud, like AWS or Snowflake