Test Connection failure in Linked Service in data factory while connecting to DB2

ADMMMLIFEADFADMIN 0 Reputation points
2024-02-22T09:59:55.43+00:00

Expectation: Data transfer from DB2 to SQL Server

Details : While providing all details in the linked service the test connection it getting failed, can you please let me know if whitelisting my IR public IP will resolve it? ERROR details : Cannot connect to the Db2 server. A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 10.133.97.12:50000 SQLSTATE=08S01 SQLCODE=-1037

Azure SQL Database
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,730 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,560 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,453 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 40,816 Reputation points
    2024-02-22T10:28:46.5933333+00:00

    After IP address I see IP Port 50000 is used; is it the right one and is it unblocked in FireWall for in-+outbound traffic?