running out of ports

From: Stefan Berglund (keepit_at_in.thegroups)
Date: 01/19/05

  • Next message: Jose Molina: "Re: Setting up local SQL Server Regeistration" 
    Date: Wed, 19 Jan 2005 09:31:21 -0800

    netstat -a yields the following:

    Active Connections

      Proto Local Address Foreign Address State
      TCP stefs-server1:smtp stefs-server1:0 LISTENING
      TCP stefs-server1:http stefs-server1:0 LISTENING
      TCP stefs-server1:epmap stefs-server1:0 LISTENING
      TCP stefs-server1:https stefs-server1:0 LISTENING
      TCP stefs-server1:microsoft-ds stefs-server1:0
    LISTENING
      TCP stefs-server1:1025 stefs-server1:0 LISTENING
      TCP stefs-server1:1026 stefs-server1:0 LISTENING
      TCP stefs-server1:1032 stefs-server1:0 LISTENING
      TCP stefs-server1:1051 stefs-server1:0 LISTENING
      TCP stefs-server1:1076 stefs-server1:0 LISTENING
      TCP stefs-server1:ms-sql-s stefs-server1:0 LISTENING
      TCP stefs-server1:3372 stefs-server1:0 LISTENING
      TCP stefs-server1:4152 stefs-server1:0 LISTENING
      TCP stefs-server1:6051 stefs-server1:0 LISTENING
      TCP stefs-server1:6052 stefs-server1:0 LISTENING
      TCP stefs-server1:6150 stefs-server1:0 LISTENING
      TCP stefs-server1:6935 stefs-server1:0 LISTENING
      TCP stefs-server1:6936 stefs-server1:0 LISTENING
      TCP stefs-server1:6937 stefs-server1:0 LISTENING
      TCP stefs-server1:6938 stefs-server1:0 LISTENING
      TCP stefs-server1:6939 stefs-server1:0 LISTENING
      TCP stefs-server1:6940 stefs-server1:0 LISTENING
      TCP stefs-server1:6941 stefs-server1:0 LISTENING
      TCP stefs-server1:6942 stefs-server1:0 LISTENING
      TCP stefs-server1:6943 stefs-server1:0 LISTENING
      TCP stefs-server1:6944 stefs-server1:0 LISTENING
      TCP stefs-server1:6945 stefs-server1:0 LISTENING
    .
    .
    .
    .
    This continues for five or six thousand ports. What gives? The
    machine recently ran for 56 days with no problems. I had to
    reboot it because of this problem and now every couple of days it
    runs out of connections and has to be rebooted.

    SQL Server is the only software running on the box and SELECT
    @@VERSION yields:

    Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002
    14:22:05 Copyright (c) 1988-2003 Microsoft Corporation
    Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

    Any ideas? Is there a more appropriate group? 

    ---
Stefan Berglund
  • Next message: Jose Molina: "Re: Setting up local SQL Server Regeistration"

    Relevant Pages

    • Re: running out of ports
      ... Suggest you use TCPView to determine what process owns those ports - it may ... > Active Connections ... > reboot it because of this problem and now every couple of days it ... > SQL Server is the only software running on the box and SELECT ...
      (microsoft.public.sqlserver.security)
    • Re: upgrading from isa2000
      ... There may be active connections that need to be stopped. ... The old FWC requires a reboot of the machine if its serving connections. ... But what about the firewall client. ...
      (microsoft.public.isa.configuration)
    • Re: Remote desktop unable to connect on local network
      ... Typing netstat -ano yields: ... Active Connections ... I tried connecting the laptop directly to the Pro machine with a crossover cable and still got the same error message when trying to connect, so I don't think the problem is the router. ...
      (microsoft.public.windowsxp.work_remotely)