Cannot access MSSQL db

James Cameron cameron at fax.sno.cpqcorp.net
Mon Apr 8 20:05:52 EDT 2002


David Nordenberg wrote:
> bash-2.05$ ./sqsh -H 192.168.1.97

Note that the text following -H must be a host name in the
/etc/freetds/freetds.conf configuration file.  Is it?

> src/tds/login.c: tds_connect: 212.181.91.6:4000: Connection refused
> hmm, BBIIGG HMMM. 212.181.91.6 is webrouter0.telia.nic.nu and I have no
> idea where that came from???

Nor I.  Check your configuration file.  You should also find that
tcpdump is showing a connection attempt to port 4000 on that host.

Port 1433 is the usual port.

Have a look at TDSDUMP output.
Validate the origin of the configuration files using;

$ strace -o sqsh.log sqsh -H hostname
$ grep open sqsh.log

-- 
James Cameron                                 (james.cameron at compaq.com)

http://quozl.linux.org.au/         (or)         http://quozl.netrek.org/



More information about the FreeTDS mailing list