Microsoft Integration Runtime Configuration Manager returns "internal client error" when connecting to MySQL

Roust_m 1 Reputation point


I've built few new VMs in AWS and installed Microsoft Integration Runtime Configuration Manager. On some of them it works fine, on others it returns:
"[Microsoft][MySQL] (42) Internal client error.
ERROR [HY000] [Microsoft][MySQL] (42) Internal client error."

The connection to the same MySQL server works fine on the same box if I use ODBC Data Source Administrator (64 bit).

Any ideas?


Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
8,524 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Roust_m 1 Reputation point
    0 comments No comments

  2. Roustam Akhmetov 1 Reputation point

    We found a workaround, by disabling a windows firewall you can make it work on this particular server. Other servers do not require firewall to be disabled to make it work. Wondering what port (or ports) should I allow to keep the firewall running and the connectivity working?

    0 comments No comments