FreeTDS Development Group

[Javier Oviedo <joviedo AT plcendesa.com>]

ZIGLIO, Frediano, VF-IT wrote:

>>Hi michael
>>
>>I check my SQL Server configuration and it listen on port 1433 and ip 
>>172.25.X.X . I can connecto to SQL from my laptop with Toad 
>>and SQL 2005
>>Manager.
>>This is the output from tsql -C:
>>
>> tsql -C
>>Compile-time settings (established with the "configure" script):
>>                           Version: freetds v0.63
>>    MS db-lib source compatibility: no
>>       Sybase binary compatibility: unknown
>>                     Thread safety: yes
>>                     iconv library: yes
>>                       TDS version: 8.0
>>                             iODBC: yes
>>                          unixodbc: no
>>
>>Regards
>>    
>>
>
>  
>
Hi freddy77

>Usually we suggest following steps
>- ping if hostname used. Does machine resolve ip from name?
>  
>
ping sqlserver
PING sqlserver (172.25.X.X) 56(84) bytes of data.
64 bytes from sqlserver (172.25.X.X): icmp_seq=0 ttl=123 time=9.85 ms
64 bytes from sqlserver (172.25.X.X): icmp_seq=1 ttl=123 time=10.1 ms
64 bytes from sqlserver (172.25.X.X): icmp_seq=2 ttl=123 time=9.91 ms

>- telnet to sql port. This avoid problems with firewall and similar
>  
>
 telnet 172.25.X.X 1433
Trying 172.25.X.X...
telnet: Unable to connect to remote host: Connection refused

I can't do telnet to an sql port from linux but I can connecto to an SQL
Server with my laptop . My laptop this one in the same subnet that the
linux machine.

>- tsql with -H -p -U -P to check lower FreeTDS layer (libTDS)
>  
>
 tsql -H sqlserver -p 1433 -U **
locale is "en_US.UTF-8"
locale charset is "UTF-8"
Password:
src/tds/login.c: tds_connect: 172.25.X.X:1433: Connection refused
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 with -S -U -P to check for freetds.conf configuration
>  
>
 tsql -S 172.25.X.X  -U ** -P ***
locale is "en_US.UTF-8"
locale charset is "UTF-8"
src/tds/login.c: tds_connect: 172.25.X.X:1433: Connection refused
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

>- try with same parameter on upper layer (PHP script and similar)
>
>freddy77
>_______________________________________________
>FreeTDS mailing list
>FreeTDS AT lists.ibiblio.org
>http://lists.ibiblio.org/mailman/listinfo/freetds
>
>
>  
>
Regards!