MS SQL Server / Azure SQL: On Mac connection failed with OpenSSL library could not be loaded error or TCP Provider: Error code 0x2746

When you try to connect to MS SQL Server / Azure SQL from Mac, you might see either of the below errors and cannot connect to your database.

[08001][Microsoft][ODBC Driver 17 for SQL Server]SSL Provider: [OpenSSL library could not be loaded, make sure OpenSSL 1.0 or 1.1 is installed]
[08000][Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: Error code 0x2746 [Microsoft][ODBC Driver 17 for SQL Server]Client unable to establish connection

If this is the case, please follow the SQLServer - Exploratory to fix the issue.