Post reply

How to Connect to Azure Database for MySql

  • February 15, 2024 at 12:47 pm

    #4379146

    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

     

     

    Attachments:
    You must be logged in to view attached files.

  • February 15, 2024 at 3:43 pm

    #4379241

    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

    #4379631

    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