Free TDS compiled ok but I can't connect

Ken Tozier <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <[email protected]>
Hi

I downloaded FreeTDS today and configured and installed with the  
following

./configure --prefix=/usr/local/freetds --enable-msdblib --with- 
tdsver=8.0
make
sudo make install

Next I opened the freetds.conf file and edited the default MSSQL  
setup to read (from memory)

[PMXDB]
	host = <name>.<domain>.com
	port = 1433
	user = <user>
	tds version = 8.0

Then I tried to do the tsql connect tests using

/usr/local/freetds/bin/tsql -H <name>.<domain>.com -p 1433 -U <user>

Which yeilds the following error:

Msg 18456, Level 14, State 1, Server , Line 0
Login failed for user '<user>'.
Msg 20002, Level 9, State -1, Server OpenClient, Line -1
Adaptive Server connection failed
There was a problem connecting to the server

Running /usr/local/freetds/bin/tsql -C yeilds

locale is "C"
locale charset is "646"
Compile-time settings (established with the "configure" script):
                    Version: freetds v0.62.dev.20030804
     MS db-lib source compatibility: yes
          Sybase binary compatibility: no
                                   Thread safety: yes
                                      iconv library: yes
                                      TDS version: 8.0
                                                iODBC: yes
                                            unixodbc: no

The thing is, I know for a fact that the host and user are valid so  
why can't I connect?

Any help appreciated
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.