Skip to Content.
Sympa Menu

freetds - RE: [freetds] Error connecting to SQL Server 8.0 using tsql

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Danny Raetzsch" <danny AT msc.tamu.edu>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: RE: [freetds] Error connecting to SQL Server 8.0 using tsql
  • Date: Sat, 11 Dec 2004 00:31:00 -0600

This is exactly what I'm getting when the "force protocol encryption" option
is enabled on the server.

Dan


-----Original Message-----
From: freetds-bounces AT lists.ibiblio.org on behalf of James K. Lowden
Sent: Fri 12/10/2004 7:15 AM
To: Hugo Barbosa; FreeTDS Development Group
Subject: Re: [freetds] Error connecting to SQL Server 8.0 using tsql

Hugo Barbosa <hugo.barbosa AT gmail.com> wrote:
>
> I'm using FreeTDS 0.62 and Fedora Core 2, trying to connect to MS SQL
> Server 8.0 in Windows 2000.
...
> Msg 20004, Level 9, State 0, Server OpenClient, Line 0
> Read from SQL server failed.
...
> The same message is returned if I use "-S server_name" or "-H
> host_name -p port".
...
> Starting log file for FreeTDS 0.62.4
> on 2004-12-10 08:55:20 with debug level 99.
...
> 08:55:20.282173 Connecting to 10.11.120.83 port 3389, TDS 8.0.
...
> 08:55:20.282867 tds_process_login_tokens()
> 08:56:20.287728 goodread: errno=104, "Connection reset by peer"
> 08:56:20.287809 tds_client_msg: #20004: "Read from SQL server
> failed.". Connection state is now 0.

As you surmised, "Connection reset by peer" is your trouble. It's not an
authentication problem, though. If it were, the server wouldn't just drop
the connection; it's not that rude. It would return a rejection message.


Hmm. I should write that down somewhere: In a TDSDUMP log, authentication
problems always show a packet coming back from the server.

Is the server definitely listening for TCP/IP connections, and not just
named pipes? (I don't know if such a setup would answer to telnet
connections.) Using Microsoft's tools, can a TCP/IP client connect?

Is there any chance that the server isn't actually listening on 3389, but
something else is? Is there an intervening firewall?

You might try TDSVER = 7.0 or TDSVER = 4.2. Beware 4.2 will expose the
login packet to the TDSDUMP log.

FreeTDS definitely knows how to connect to SQL Server 2000. The fact that
the connection is abruptly dropped leads me to think its a low-level
communications setup issue.

--jkl
_______________________________________________
FreeTDS mailing list
FreeTDS AT lists.ibiblio.org
http://lists.ibiblio.org/mailman/listinfo/freetds



<<winmail.dat>>




Archive powered by MHonArc 2.6.24.

Top of Page