Share via

Facing error for MySQL connectivity from Synapse Linked Service

Sudarshan Bhamare 45 Reputation points
2024-03-21T11:49:26.41+00:00

I'm trying to created a Linked Service to Mysql Server hosted on AWS Server. But it is giving me: ERROR [08001] [Microsoft][MySQL] (1004) The connection has timed out while connecting to server: 10.xx.xx.xx. at port: 3306. with Error Code 9603. My other sql server linked service are able to connect in same way using Self hosted integration runtime but only Mysql linked service is failing. I am able to ping the sql server from my self hosted integration runtime and vice versa. Is there anything im missing out here. Thank you in advance.

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,471 questions
Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
726 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,752 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247-1375 11,396 Reputation points
    2024-03-21T14:26:47.5833333+00:00

    Hi Sudarshan Bhamare,

    Thanks for reaching out to Microsoft Q&A.

    Try the following to narrow down the issue, possibly one of the below should work for you.

    • Outbound IP Addresses - Ensure that the IP addresses used by ADF are added to the “Outbound IP” list in your AWS MySQL configuration. This step is crucial for allowing communication between ADF and your MySQL server.
    • Firewall Rules - Verify that port 3306 (the default MySQL port) is open for outbound connections. Set up firewall rules to allow traffic from the Self-Hosted Integration Runtime (SHIR) machine IP address to your MySQL server.
    • Timeout Settings - Review the timeout settings in the linked service configuration in Azure Data Factory. You may need to adjust the connection timeout value to accommodate any latency or network delays between ADF and the MySQL server.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.