Forum Discussion
Issues connecting to MySQL database server using virtual network data gateway in Fabric
I managed to connect to connect to the external MySQL server using a Self-hosted Integration Runtime with a static IP address in Azure Data Factory. No luck in doing it in Fabric. I have not been able to raise a support ticket as I for some reason do not had access to do so.
Hi!
Unfortunately, the connection issue still exists, and the advice given has not been able to resolve the issue. I have confirmed that port 3306 is open. When I troubleshoot the network in Fabric, I can see that the source adress indeed is an adress in my whitelisted subnet address range, and the remote adress is the adress of the MySQL database. However, the TCP test and ping still both fail.
Hello Anonymous ,
Thank you for the update! Since the source address matches the whitelisted subnet but both the TCP test and ping fail, the issue is most likely on the MySQL provider’s side. Please confirm with the provider if they block ICMP (ping) or TCP connection probes from external services like Azure, as some providers restrict such requests for security reasons.
Additionally, verify if the provider enforces SSL/TLS connections and ensure the correct certificates are provided during the connection setup in Fabric. It is also worth checking if the provider allows connections only from specific client types or if they block requests from cloud-based services like Azure. If everything seems correctly configured, request the provider to check their firewall logs for any blocked connection attempts.
If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hello @beryil ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.Hello Anonymous ,
Unfortunately still no solution, and I have given the hopes of connecting to the database using a VNet Data Gateway in Fabric. Instead, I am now trying fetch data from the MySQL database using Azure Data Factory. I plan to ask a new question related to this approach as it also has some issues.
Hello Anonymous,
Thank you for confirming. We apologize for the inconvenience caused by the ongoing issue.
To address this effectively, please raise a support ticket with Microsoft. This will enable the engineering team to investigate the issue in detail and provide a resolution or guidance.
To raise a support ticket for Fabric and Power BI, kindly follow the steps outlined in the following guide:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft LearnThank you for being a part of the Microsoft Fabric Community.