Connect to Azure Database for MySql from SSIS failed with error

Raj Maddala 20 Reputation points
2024-02-21T15:59:47.2933333+00:00

Hi, I am trying to connect to Azure Database for Mysql from SSIS. I have installed the connector (MySql connector for NET ADO) I have entered the server name, username (MySql database username) and password and the port 3306. When I clicked Test Connection, I am getting error. Please see attached What is the issue? How can I connect? Thanks in advance

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
713 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,454 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vahid Ghafarpour 17,950 Reputation points
    2024-02-21T16:04:43.27+00:00

    Try to connect to the Azure Database for MySQL using MySQL Workbench or another MySQL client tool from the SSIS server. This can help verify if the issue is specific to SSIS or if it is a more general connectivity problem.

    ** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **