Re: TCP connections suddenly failing.

Tech-Archive recommends: Fix windows errors by optimizing your registry

The clusteipaddr was fine on both instances on both all servers within
the cluster.

I want a root cause, but we took the cluster group offline and brought
it back online and that resolved the TCP connect issue.



On Apr 17, 5:51 am, "Gabe Matteson" <gmatteson.rounder.com.nospam>
wrote:
Can you check
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Cluster
and make sure the clusteripaddr is set to the virtual server ip?

<ken.sum...@xxxxxxxxx> wrote in message

news:8n0823tmas9r1tia19u6v6193fsl8glt3i@xxxxxxxxxx



I am running a large mission critical application on a cluster. This
is a 2003 server latest SP with SQL 2000 Enterprise latest SP also.

This app has run for years with little change. Today at around 3:00
all connections stopped coming in.

After some debugging, we found that we could connect with named
pipes., but not TCP. TCP has been the default protocol for years.

We have the server monitored and no changes occurred recently. The
server has not been rebooted in months, and the last time the instance
was restarted was two months ago.

What can cause a server that has run reliably using TCP for years to
stop accepting TCP connectionsl suddenly?

The errors I am getting is a handshake error trying to connect locally
using TCP, and I get a connection failed error remotely.

Connections are instant and lovely using named pipes.

Thanks for any help.- Hide quoted text -

- Show quoted text -


.

Relevant Pages

  • Re: TCP/IP redundant connections
    ... The clients have persistent TCP connections to the server, ...
    (freebsd-hackers)
  • Re: freebsd-hackers Digest, Vol 233, Issue 3
    ... The clients have persistent TCP connections to the server, ... So I want to utilize IP-sharing and TCP-connection synchronization ...
    (freebsd-hackers)
  • Re: Component Efficiency
    ... Desktop OSes have TCP backlog limit of 5 outstanding ... TCP connection attempts, e.g. up to five clients may be ... simultaneously establishing connections. ... suitable for any kind of TCP server, ...
    (microsoft.public.win32.programmer.ole)
  • Re: TCP connections suddenly failing.
    ... do you have a lot of .Net client application connections? ... Microsoft SQL Server MVP ... it back online and that resolved the TCP connect issue. ... >> Connections are instant and lovely using named pipes. ...
    (microsoft.public.sqlserver.clustering)
  • Re: affinity remapped when a new host is added
    ... like SSL connections, it is required because using 2 or more servers would ... MVP - Windows Server - Clustering ... > If a host is added to the cluster, convergence allows this host to receive ... > Internet clients and to server applications. ...
    (microsoft.public.windows.server.clustering)