Ports

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


Date: Wed, 17 Nov 2004 09:20:46 -0800

I hope this is okay, but I'm reposting this here as I
didn't get any response in the Security forum:

"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

  • Double Hop security question
    ... I am running into the "double hop" security issue using web parts to ... attempting to access the SQL Server as NT AUTHORITY\ANONYMOUS LOGON. ... used to access SQL Server in a situation where the "double hop" ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: 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.security)
  • Ports
    ... I need to find out what tcp ports Sql Server 2000 needs. ... 1433 is the standard network-accessed port, ... to access Sql Server? ...
    (microsoft.public.sqlserver.security)
  • Re: Ports
    ... > 1433 is the standard network-accessed port, ... > ports has had any traffic in the last three months. ... > to access Sql Server? ... > standard ports used for anything Sql Server related, ...
    (microsoft.public.sqlserver.server)
  • Re: Strange failed Logins
    ... Do thoe logins exist in SQL Server? ... weak passwords. ... then close the ports on the firewall. ... Server security resources site for guidelines: ...
    (microsoft.public.sqlserver.security)