Facing error for MySQL connectivity from Synapse Linked Service

Question

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.

Answer 1

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.