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

Anonymous — Sat, 16 Nov 2024 02:43:24 GMT

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)

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

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

manodwhb — Sat, 11 Apr 2020 05:11:43 GMT

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

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

Anonymous — Sat, 11 Apr 2020 05:48:01 GMT

@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

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

JohnRMK — Sat, 11 Apr 2020 21:21:35 GMT

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

topic Re: Scheduled task's TCP/IP connection failed when running from Talend Management Console in Talend Studio

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

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

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

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