February 15, 2024 at 12:47 pm
Dear,
I need to retrieve data from Azure Database for MySql using SSIS.
I am able to connect to previous MySql database. The team has recently migrated to Azure Database for MySql.
I have given all the required info in the .Net Provider for MySql database
I have given port 3306 but still can't connect.
Error message: Attached
What am I missing?
Thanks in advance
February 15, 2024 at 3:43 pm
Do you have access through the firewall for your IP address. That's the most likely thing. This is a very common problem, with MySQL, PostgreSQL and SQL Server on Azure. Here's some info on how to deal with it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 16, 2024 at 9:52 am
Thanks, that has been resolved by firewall rules
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply