Re: running out of ports

From: Ken Schaefer (kenREMOVE_at_THISadopenstatic.com)
Date: 01/20/05


Date: Thu, 20 Jan 2005 11:35:32 +1100

Suggest you use TCPView to determine what process owns those ports - it may
not be SQL Server at all.
http://www.sysinternals.com/ntw2k/source/tcpview.shtml

Cheers
Ken

"Stefan Berglund" <keepit@in.thegroups> wrote in message
news:765tu09bc5nqggg7u0t8loi31ei0mvtoup@4ax.com...
> 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



Relevant Pages

  • running out of ports
    ... netstat -a yields the following: ... Active Connections ... This continues for five or six thousand ports. ... reboot it because of this problem and now every couple of days it ...
    (microsoft.public.sqlserver.security)
  • Re: Can SQL be told to stop listening on specific IPs on its computer ?
    ... ports on the firewall or in packet filtering on the OS network control ... >> In terms of the IPs and the web addresses, ... >> and SQL Server installed on the same server? ... >>>to tell SQL server what IPs and ports to listen on. ...
    (microsoft.public.sqlserver.security)
  • Re: port 3389 Not listening remote desktop connection
    ... It should display what IP addresses and ports your machine is mapping. ... Active Connections ... Is it listening? ... > I think that the repair installation is your best option at this point. ...
    (microsoft.public.windowsxp.work_remotely)
  • Re: Deploying ASP.NET Application
    ... I think this is not about firewall port blocking, ... > SQL Server does not exist or access denied. ... deployed on that server - it has something to do with ports on the firewall ... environment to our production environment. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: SQL Server Specific Windows Firewall Exception
    ... if I've gone into the Surface Area Configuration and enabled remote ... Windows Firewall" articles than I would like. ... several policies to open different ports and/or point at different EXE's ... SQL Server 2005 so that we don't have to add a number of different program ...
    (microsoft.public.sqlserver.connect)