FreeTDS Development Group

["ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>]

> 
> Hi,
> 
> I'm trying to use FreeTDS to connect a Linux box 
> (192.168.1.4) to a MS 
> SQL SERVER 2005 (192.168.1.21).
> 
> I believe I have everything right. But I get a connection 
> refused  when 
> I try to telnet from Linux to Windows. Oddly enough, other 
> machines on 
> the same network can get through with no problems.
> 
> 
> I have this in freetds.conf:
> [tds]
> host = 192.168.1.21
> port = 1433
> tds version = 8.0
> 
> # tsql -S 'PTSQL-WWLIB\sql2005' -P secret -U sa
> locale is "en_US.ISO-8859-1"
> locale charset is "ISO-8859-1"
> There was a problem connecting to the server
> 

Probably server is not using port 1433. -S specify a freetds.conf 
configuration so 'PTSQL-WWLIB\sql2005' is not correct.

Try with

[tds]
host = 192.168.1.21
instance = sql2005
tds version = 8.0

# tsql -S tds -U sa

Probably you want to connect to instance sql2005 of 192.168.1.21. Newer 
version support server\instance syntax like MS ODBC.

> # tsql -H tds -U sa
> locale is "en_US.ISO-8859-1"
> locale charset is "ISO-8859-1"
> Password:
> Msg 20009, Level 9, State 0, Server OpenClient, Line 0
> Server is unavailable or does not exist.
> There was a problem connecting to the server
> 
> tsql -C shows:
> "# tsql -C
> Compile-time settings (established with the "configure" script):
>                             Version: freetds v0.64
>      MS db-lib source compatibility: no
>         Sybase binary compatibility: unknown
>                       Thread safety: yes
>                       iconv library: yes
>                         TDS version: 5.0
>                               iODBC: no
>                            unixodbc: yes"
> 
> Any help would be appreciated.
> 
> Warm Regards,
> Mário Gamito

freddy77