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