Skip to Content.
Sympa Menu

freetds - Re: [freetds] Connection Errors...

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "James K. Lowden" <jklowden AT freetds.org>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Connection Errors...
  • Date: Fri, 17 Jun 2005 22:38:52 -0400

Rick D Conner wrote:
>
> I have to ask for some help because I'm at the end of my rope with this.
> First off, I'm restricted in that the web host has the "real" control
> over the freetds configurations, but they will take "suggestions".
...
> We are on a unix box, running apache. if it's necessary I can get the
> ver
> #'s .. And we are connecting to a remote mssql server running MsSql
> #server
> 2000.
> 15:33:45.275589 Connecting to 66.208.184.170 port 1433, TDS 7.0.
...
> 15:38:45.787660 goodread: errno=104, "Connection reset by peer"
> 15:38:45.787717 tds_client_msg: #20004: "Read from SQL server failed.".
> Connection state is now 0.
...
> If you notice on the freetds.log file, there is a 5 minute "pause" where
> the connection is finally reset by the peer (mssql server I'm assuming).
> Now, before you say the same thing that my host did, I HAVE checked the
> username and password, and they are correct. I even setup a new account
> on the mssql server and tried it to no avail..

>From the host making the connection, does "telnet 66.208.184.170 1433"
work? I bet it doesn't. Is there a firewall in between?

If the address were invalid or the server were listening on a different
port, you'd get an immediate failure. The fact that there's a 5-minute
pause says to me the server accepted the connection, but couldn't transmit
it back to the client.

(Excellent detail in your problem report, by the way, if I may say so.)

HTH.

--jkl




Archive powered by MHonArc 2.6.24.

Top of Page