question

AdalbertoGarcaEspinosa-7187 avatar image
0 Votes"
AdalbertoGarcaEspinosa-7187 asked ShaikMaheer-MSFT commented

Copy Activity

I'm configuring a Azure LinkService and getting this error.

Do you know how to solve it?

112701-screen-shot-2021-07-07-at-163409.png


azure-data-factory
· 4
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Are you trying to connect to On premise SQL Server? Probably something wrong with the FQDN.. Can you share the format that you are using.

0 Votes 0 ·

Hi @AdalbertoGarcaEspinosa-7187 ,

Thank you for posting query. It would be great if you can share below details to repro scenario and help you.

  • Mentioned linked service is pointing to which type of resource?

  • Could you please check your Fully qualified domain name field value format? It seems something might be wrong in the format of it.

Thank you.

0 Votes 0 ·

ISorry. It's a linked service to an Azure MySql Database.

0 Votes 0 ·

Hi @AdalbertoGarcaEspinosa-7187 ,

Following up to check is below provided answer helps you? If yes, Please Accept Answer. Accepting answer helps community too. Thank you.

0 Votes 0 ·

1 Answer

ShaikMaheer-MSFT avatar image
0 Votes"
ShaikMaheer-MSFT answered ShaikMaheer-MSFT commented

Hi @AdalbertoGarcaEspinosa-7187 ,

Thank you for confirming your linked service type(Azure database for MySQL).

Its seems your "Fully qualified domain name" field value is not in a correct format.

Kindly use <server>.mysql.database.azure.com format to define fully qualified domain name and check.

To know more about Azure database for MySQL linked service properties please check below link.
https://docs.microsoft.com/en-us/azure/data-factory/connector-azure-database-for-mysql#linked-service-properties

Hope this will help. Thank you.


  • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.

  • Want a reminder to come back and check responses? Here is how to subscribe to a notification.

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you. That help. I could solved the issue with the Azure database.

I I have another two strange cases. I have to Mysql database running on AWS. I configured a connection using the Azure Mysql connector. One worked fine, but the other is having the same issue I stated before with the Azure Mysql database. What do you think is happening? One AWS Mysql is working fine and the other it's not.

0 Votes 0 ·
ShaikMaheer-MSFT avatar image ShaikMaheer-MSFT AdalbertoGarcaEspinosa-7187 ·

Hi @AdalbertoGarcaEspinosa-7187 ,

Glad to know that helped.

Is your other MySQL is in some different virtual network? It would be great if you can share more details along with error screenshots.
Please feel free to open new thread to look in to. Thank you.

0 Votes 0 ·