TinyTds::Error (Unable to connect: Adaptive Server is unavailable or does not exist

[Saritha Chakilala]

I am trying to connect azure sql server.

client = TinyTds::Client.new(:username =>'######', :password => '$$$$$$', :host => '****.database.windows.net',  :azure => 'true', port: 1433)

below are the details:

$gem list show tiny_tds

*** LOCAL GEMS ***

tiny_tds (2.1.2, 2.1.1, 2.1.0)

$tsql -C

Compile-time settings (established with the "configure" script)

                            Version: freetds v1.00.82

             freetds.conf directory: /etc/freetds

     MS db-lib source compatibility: no

        Sybase binary compatibility: yes

                      Thread safety: yes

                      iconv library: yes

                        TDS version: 4.2

                              iODBC: no

                           unixodbc: yes

              SSPI "trusted" logins: no

                           Kerberos: yes

                            OpenSSL: no

                             GnuTLS: yes

                               MARS: no