SQL Azure Connection Hangs or Times-out on Mac

After one of the macOS Sierra updates, encrypted connections to SQL Azure from RazorSQL started to time-out or hang on some Mac machines with certain network configurations. To resolve this issue, the following can be tried. The following steps have resolved the issue for most users.

1. open terminal (/Applications/Utilities/Terminal)

2. type scutil --get HostName (this is case sensitive) and then press return

3. If the hostname is not set or contains .local, type sudo scutil --set HostName "newHostName" and then press return

4. Try the Azure Connection again