We need to run a series of T-SQL statements (to create database objects and inert data) on an Azure SQL databases (not Managed Instance database flavour).
We successfully tested that we can and run the sql commands from the Linux VM having installed odbc drivers.
However, we get connection timeout errors when we try to run the sql scripts using Ansible, from the same Linux VM.
Ansible uses ssh (port 22) to connect to remote hosts. SQL server communicates on Port 1433.
Is what we are trying to do supported by Ansible?
If supported, please could someone point us to how this can be achived.
Thank you