Azure SQL Database
An Azure relational database service.
5,672 questions
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
1 answer
Sort by: Most helpful
-
Olaf Helper 44,501 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,011 Reputation points Microsoft Employee2024-02-22T23:45:37.6666667+00:00 Hello ADMMMLIFEADFADMIN Did you try with ODBC driver? and test the connection
-
Bhargava-MSFT 31,011 Reputation points Microsoft Employee
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 -