Re: Ports

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 11/17/04 

Date: Wed, 17 Nov 2004 13:04:29 -0500

I just answered your question in microsoft.public.sqlserver.server

Steve
"Cal" <anonymous@discussions.microsoft.com> wrote in message
news:715301c4cbf7$8a9d1ed0$a301280a@phx.gbl...
> I need to find out what tcp ports Sql Server 2000 needs.
> 1433 is the standard network-accessed port, right? And
> isn't it 80 that the web comes through?
>
> The reason I'm asking is because our security group came
> by and showed me a list of ports mapped from our web
> servers through the firewall to various of my production
> sql servers. Furthermore, they know that none of these
> ports has had any traffic in the last three months. So of
> course they would like to close these access holes up
> since they're not being used.
>
> Most of these dead ports are 1433 which is incorrect
> right? i.e. the web would not generally directly hit 1433
> to access Sql Server? Plus isn't that a security risk?
>
> I also see 1100, 1199, 7050 mapped in? Those aren't
> standard ports used for anything Sql Server related, right?
>
>

Relevant Pages

  • 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: 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)
  • Re: SQL Server 2005 Transaction VPN Firewall
    ... den MSDTC habe ich eingerichtet, wenn ich die Firewall alle Ports aufmache, ... Kann man die Verbindung nicht auf einen festen Port legen? ... wie geht das in SQL Server 2005? ... Ports da genutzt werden. ...
    (microsoft.public.de.sqlserver)
  • Ports
    ... "I need to find out what tcp ports Sql Server 2000 needs. ... The reason I'm asking is because our security group came ... to access Sql Server? ...
    (microsoft.public.sqlserver.server)
Quantcast