Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,427 questions
Job Failing Repeatedly with TCP/IP to the host not found
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 41%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETA%3C/text%3E%3C/svg%3E)
TEHRA Abhishek (External)
0
Reputation points
Hello Team,
We have ETL talend job scheduled from TMC which is running from different execution server. Most of the jobs are failing with an error "The TCP/IP connection to the host eunpbrdbmerepsql01.database.windows.net, port 1433 has failed. Error: "connect timed out. 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."". In the next run it is running successful.
We have checked with the Talend vendor and they asked us to check with Microsoft.
Can you please help us identifying the root cause and the solution for this issue.
Regards,
Abhishek Tehra
{count} votes
-
msrini-MSFT 9,281 Reputation points Microsoft Employee2024-04-11T09:34:08.6333333+00:00 Hi,
For intermittent connectivity issue, deeper level investigation is required.
Where is the source located ? Is it On-Prem ? Can you try tracert from Source to destination and check which path it takes and see of there are any increase in RTT ?
When you try to connect to the same DB from a different site, lets say an Azure VM, are you seeing any issues ?
First you can try to narrow down the problem to see if this is an issue from Source or at the DB. You can perform some troubleshooting and share more details here to isolate the problem.
Regards,
Karthik Srinivas
-
KapilAnanth-MSFT 45,111 Reputation points Microsoft Employee2024-04-12T06:46:51.46+00:00 Welcome to the Microsoft Q&A Platform. Thank you for reaching out & I hope you are doing well.
I am afraid your verbatim does not provide a complete picture of your architecture or your requirement.
- I see you are trying to access Azure SQL Database over internet ?
Is the above statement correct? if not, please let us know your environment - Can you please share what exactly your source is?
- Is it an OnPrem machine trying to connect via Internet?
Cheers,
Kapil
- I see you are trying to access Azure SQL Database over internet ?
Sign in to comment
Sign in to answer