I have 2 azure VMs 1st is Linux machine(ubuntu 18.04) and 2nd is windows azure vm. I have MySql database in Linux machine. I want to move the data from Linux MySql database to SQL Server Database which is hosted on windows Azure machine. I am creating a SSIS package to perform this operation but I am not able to connect to the Linux machine, I have open all the required ports (22,3306,1433) ports in all inbound and outbound rules in both vm but still I am not able to create successful connection.
Both the servers are in same vnet and load balancer is not applicable.
Sharing the answer as per the comment by the original poster.
For me the main criteria was to connect with mysql (Linux machine) from ssis (windows machine). The issue is with the user we were using, we created a user and provided all the rights to that new user, from this new user we are able to connect.