freetds - Unable to connect: Adaptive Server is unavailable or does not exist -


while trying connect remote sql server:

$tsql -s localhost -u myuser 

i got error like:

locale "en_us.utf-8" locale charset "utf-8" using default charset "utf-8" error 20009 (severity 9):     unable connect: adaptive server unavailable or not exist     os error 61, "connection refused" there problem connecting server 

the output of $tsql -c below:

compile-time settings (established "configure" script)                         version: freetds v0.91          freetds.conf directory: /usr/local/freetds/conf/freetds  ms db-lib source compatibility: no     sybase binary compatibility: no                   thread safety: yes                   iconv library: no                     tds version: 5.0                           iodbc: no                        unixodbc: no           sspi "trusted" logins: no                        kerberos: no 

i have created tunnel remote server like:

$ssh -l 1433:db_server:1433 user@mid_server 

this forward local port 1433 db_server. tested. ssh tunnel works because can connect database using navicat (localhost on 1433). can telnet localhost on port 1433.

i kinda worked modifying freetds.conf

from

[global]     # tds protocol version ;   tds version = 4.2 

to

[global]     # tds protocol version tds version = 7.0 

Comments