Unable to resolve Azure database for mysql name from Data Factory

Ignacio Sales 5

I am creating a linked service from my Azure Data Factory environment, to access my Azure Database for Mysql database. I select "Azure database for Mysql", and I can see all my mysql servers. I select "From Azure subscription" as the account selection method, and I can see the server I want to connect to in the drop down list. I am also able to see all the schemas in that server. I then enter a valid username / pwd which I can use to connect to that server, but when I test the connection I get the error "The value of the property '' is invalid: 'The remote name could not be resolved: 'xxxxxxx.mysql.database.azure.com''. with error code 11402

I guess it is a networking issue, but I can't understand how the server is visible, and I am able to see all the schemas in it, but then the actual connection fails. My database service is in a Virtual Network, but I can't figure out how to give access to that network to the Azure Data Factory environment.

PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-07T13:19:26.75+00:00
@Ignacio Sales - Thanks for the question and using MS Q&A platform.

It seems like you are facing a connectivity issue while creating a linked service from Azure Data Factory to Azure Database for MySQL. The error message "The remote name could not be resolved" indicates that the DNS resolution failed for the MySQL server name.

First thing to check:

An existing Azure database for MySQL Single server or MySQL Flexible Server with public access or private endpoint.

Enable Allow public access from any Azure service within Azure to this server in networking page of the MySQL server . This will allow you to use Data factory studio.

For more details, refer to Copy and transform data in Azure Database for MySQL using Azure Data Factory or Synapse Analytics

You can add your Azure Data Factory to the same virtual network as your Azure Database for MySQL or peer the virtual network that your Azure Data Factory is in with the virtual network that your Azure Database for MySQL 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 Azure Database for MySQL.

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

I hope this helps. Let me know if you have any further questions.
PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-09T05:23:47.39+00:00

@Ignacio Sales - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ignacio Sales 5 Reputation points

2024-05-09T16:41:46.4566667+00:00

@PRADEEPCHEEKATLA

Thanks for your input. Unfortunately we are still experiencing issues.

To provide some more details, the MySQL resource we are trying to connect our data fabric to is of type "Azure Database for MySQL flexible server".

Its networking configuration screen does not show the option to "Allow public access from any Azure service within Azure to this server". The only information I can see on the networking screen is the Virtual Network and subnet on which the resource is defined. I also see the following information with regards to the subnet:

It also shows that the resource is on private DNS Zone.

I tried to create a new DataFabric resource, specifying a Managed Virtual Network and a Private Endpoint. The configuration menu options do show the Virtual Network and subnet which are listed on the MySQL resource, but when I select them the errors: "The selected subnet <subnetname> has delegation and can not be used." and "The selected subnet <subnetname> has delegation and can not be used with a private endpoint.". So I did not complete the creation of this new DataFabric.

Finally, I tried to create a private endpoint from my previously existing DataFabric, but although the request seems to be created successfully, it never appears as ready to be approved, and the following errors appear on the activity log of the MySQL resource (I guess because of the fact that it is using a delegated subnet):

I have tried looking for specific documentation about the error but without much luck. Any further input would be much appreciated.

Ignacio
PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-10T03:19:30.3833333+00:00

@Ignacio Sales - I agree that this issue looks strange and I wasn't able to reproduce this issue. If you have a support plan could you please file a support ticket for deeper investigation and do share the SR# with us?
PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-14T04:07:46.8233333+00:00

@Ignacio Sales - Did you get a chance to open a support ticket to resolve the issue?
Ignacio Sales 5 Reputation points

2024-05-15T16:37:18.66+00:00

@PRADEEPCHEEKATLA I did create the case and was chatting to an engineer about it today. We were not able to resolve it online though, so they keep working on it. The case nlumber is 2405150050004367
PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-16T06:05:01.59+00:00

@Ignacio Sales - Thanks for sharing the support request number. Once the issue has been resolved with the help of support, request to share the solution, which might be beneficial to other community members reading this thread.
Ignacio Sales 5 Reputation points

2024-05-27T15:48:41.66+00:00

@PRADEEPCHEEKATLA Things are moving pretty slowly with support. After a couple of screen sharing sessions the only new information I got is a more explicit statement of what seems to be the problem, which is that "The server 'xxxxxx' is VNet injected and does not support the creation of private endpoints." (that came from the JSON payload of the failure event log for the private endpoint creation action). Not sure if there is any way to get around that. There are other subnets in the virtual network where my SQL server is configured, but Im not sure how (or if) I can use them from Data Fabric to connect to the database.
PRADEEPCHEEKATLA 90,511 Reputation points

2024-05-29T07:59:20.8933333+00:00

@Ignacio Sales - Thanks for the update. We will reach out to the owner of the support case to share the necessary details as required.
Ľuboš Olejár 0 Reputation points

2024-06-07T06:49:01.9733333+00:00

I have the same issue. Simply said integration runtime doesn't have an access / or is not resolving private dns records. Either public endpoint for mysql or private dns one can't be resolved ... so far only solution is to not integrate MySQL with VNet but rather create it in public mode and create endpoint with privatelink.

Share via

Unable to resolve Azure database for mysql name from Data Factory

Your answer