Skip to Content.
Sympa Menu

freetds - [freetds] Freetds + MS SQL Server 2000 on unix

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: age85 AT gmx.de
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Freetds + MS SQL Server 2000 on unix
  • Date: Wed, 8 Feb 2006 15:51:05 +0100 (MET)

Hello NG,

i try to access an MS SQL Server 2000 database with the latest stable
freetds release. I've configured and installed freetds with the following
commandline parameters --with-unixodbc=/usr/local and --with-tdsver=8.0
everything ends fine. Then I've configured the SQL Server to use the SQL
Server and Windows Authentication. But if I try:

tsql -H 192.168.100.166 -p 1272 -U Administrator

im getting the password prompt, after entering the password im getting:

Msg 20020, Level 9, State 0, Server OpenClient, Line 0
Unknown marker
Msg 20014, Level 9, State 0, Server OpenClient, Line 0
Login incorrect.
There was a problem connecting to the server

I also tried:
tsql -S myserver -U Administrator

with the following in freetds.conf:

[myserver]
host = 192.168.100.166
port = 1272
tds version = 8.0

But getting the same error message (after password entering). What could be
wrong? Any help would be greatly appreciated.

Thx René

--
DSL-Aktion wegen großer Nachfrage bis 28.2.2006 verlängert:
GMX DSL-Flatrate 1 Jahr kostenlos* http://www.gmx.net/de/go/dsl




Archive powered by MHonArc 2.6.24.

Top of Page