Azure SQL Database
An Azure relational database service.
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?
Test Connection failure in Linked Service in data factory while connecting to DB2
![](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(25.6, 47%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ADMMMLIFEADFADMIN
0
Reputation points
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.
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
SQL Server | Other
1 answer
Sort by: Most helpful
-
Olaf Helper 47,586 Reputation points2024-02-22T10:28:46.5933333+00:00 -
![](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(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator2024-02-22T23:45:37.6666667+00:00 Hello ADMMMLIFEADFADMIN Did you try with ODBC driver? and test the connection
-
Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator
2024-02-26T20:01:57.92+00:00 Hello ADMMMLIFEADFADMIN I am checking to see if you have any further questions here.
Sign in to comment -