Debugging connection to mssql

Evan Panagiotopoulos <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CAAMN46fQn73cM67Wf8GoDNeEyF=nNW0GCNdnrm+O+Ur2MSPOpw@mail.gmail.com>
I am using a freebsd server trying to connect to a mssql server.

I issue:

tsql -H KCSD-ZONE-INT -p 1433 -U osdadmin
locale is "C"
locale charset is "US-ASCII"
Password:
Msg 20004, Level 9, State 0, Server OpenClient, Line 0
Read from SQL server failed.
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

Then I try:

tsql -S KCSD-ZONE-INT -U osdadmin
locale is "C"
locale charset is "US-ASCII"
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


>From past attempts the remote server admin said that he saw the following
error:
The login packet used to open the connection is structurally invalid; the
connection has been closed. Please contact the vendor of the client
library. [CLIENT: 10.1.1.65]

I went to /usr/ports/databases/freetds and reinstalled the package. I also
restarted php and lighttpd.

in /usr/local/etc/freetds there is a interfaces.dist file where I have:
KCSD-ZONE-INT
query tcp 4.2 10.1.1.16 1433

There are other sections there but I didn't touch them.

Do you have any suggestions? How can I connect to the mssql server?
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.