Ports

From: Cal (anonymous_at_discussions.microsoft.com)
Date: 11/16/04 

Date: Tue, 16 Nov 2004 08:15:51 -0800

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)
  • 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)
  • 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)
Loading