Re: TCP connections suddenly failing.

Yes. IIRC, that is where systmem network buffers come from. By chance, do you have a lot of .Net client application connections?

--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP




<ken.sumner@xxxxxxxxx> wrote in message news:1176821541.594949.216660@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Apr 17, 9:35 am, ken.sum...@xxxxxxxxx wrote:
The clusteipaddr was fine on both instances on both all servers within
thecluster.

I want a root cause, but we took theclustergroup 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 acluster. 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 -- Hide quoted text -

- Show quoted text -

Another issus that may have had an impact is that just before the
problem started, we had a 2019 Srv error: Server was unable to
allocate from the system nonpaged pool because pool was empty.

Can this have an impact on SQL Server TCP connections only, but allow
named pipes to connect?


.

Relevant Pages

  • 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: Upgraded Win2K/ SQL 2K to Win2K3, is now one big mess
    ... TCP/IP and named pipes are both enabled, ... The TCP/IP and Named Pipe protocols need to be enabled. ... > I installed Small Business Server at home, ... the existing server connections still ...
    (microsoft.public.sqlserver.odbc)
  • Re: R2 in-place upgrade bug ? ..HELP
    ... Application protocol Protocol Ports ... Global Catalog Server TCP 3269 ... The upgraded R2 DC does not accept incoming connections, ...
    (microsoft.public.windows.server.active_directory)
  • RE: SUMMARY:RE: TCP_keepalive
    ... of short and unreliable connections). ... creating a TCP socket. ... printf "Decrease the tcp time wait interval\n" ...
    (SunManagers)