Timing out when connecting to a MSSQL database on non-default port using ODBC driver

[JuanjoFuchs]

I had to use "Microsoft SQL Server (ODBC)" data source because the "Microsoft SQL Server" one does not currently support using SSL. However, when trying to connect to my server on a port different than 1433, connection timed out.

After a bit of digging, I found this:

Microsoft's ODBC drivers for SQL Server do not use a PORT= parameter. The port number, if any, is appended to the server name/IP with a comma

source: https://stackoverflow.com/a/50051708/1277401