Connecting to a Azure MySQL instance from Data Factory Linked Service

Question

I have an Azure Mysql Instance in a Virtual Network created as part of the instance setup. I want to be able to copy data to MYSQL as a Copy Data sink. When I try to set up a connection to the MySQL instance using the AutoResolveIntegrationRuntime it resolves the Azure MySQL DB instance and the Database Names. But when I try to test the connection I get an error "11793 - Unable to connect to any of the specified MySQL hosts".

The Connectivity Menu for the MySql instance says that "Only resources within the virtual network or a peered network to your server will have access".

Is there a way that I can add the Data Factory to the Virtual Network or link it as a peered network?

Answer 1

The connectivity issue was fixed after I added the ADF Managed Identity to the MySQL IAM. I think that is what was missing.

Answer 2

@Navid Erfani-Ghadimi

Let me assume here that you are using Azure MySQL Database.

Could you please check if the data factory is in in the same VNET as the MYSQL VNET. If not, the error message is expected.

You can add your Azure Data Factory to the same virtual network as your Azure MySQL instance or peer the virtual network that your Azure Data Factory is in with the virtual network that your Azure MySQL instance is in.

Here are the steps to add your Azure Data Factory to the virtual network: see https://learn.microsoft.com/en-us/azure/data-factory/managed-virtual-network-private-endpoint.

Another solution is: if ADF is not in the same Vnet then create a managed endpoint. It establishes a private connection between ADF and MySQL DB.

 https://learn.microsoft.com/en-us/azure/data-factory/managed-virtual-network-private-endpoint#managed-private-endpoints

Please do let me if that works.

Regards,

Oury

Answer 3

I am facing the exact same issue. I have the ADF and Azure MySQL DB on the same VNet but different subnets. I get the Error 11793 while testing the connection. I have multi-auth enabled. I tried both the Entra ID and the MySQL Admin user. I then tried moving the ADF to the same subnet. But no luck. I am able to connect to the MySQL through MySQL Workbench. So the Server is active and accessible. The error too is not descriptive at all. No details. Just one line saying "Unable to connect to any of the specified MYSQL Hosts".