Re: SQL Server TCP/IP Listener Address

From: John Bell (jrm_bell@hotmail.com)
Date: 09/05/02 

From: John Bell <jrm_bell@hotmail.com>
Date: Thu, 05 Sep 2002 20:59:24 +0100

Someone posted a similar request the other day I suggested that he
used TCP/IP filtering on the TCP/IP connection in network settings,
but he never came back to say that it worked.

See

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q309798&#2

John

On Thu, 5 Sep 2002 17:00:06 +0100, "msnews.microsoft.com"
<sybourg@hotmail.com> wrote:

>Hi,
>
>I am currently setting up a SQL Server for a customer (SQL 2K) I have
>noticed that there does not seem to be any way in which to restrict/set the
>IP addresses on which SQL listens.
>
>For example, the server is a multi-homed server with three NIC's, SQL
>insists on listening on all IP's on port 1433.
>
>One NIC is connected to the internet, this means that in order to prevent
>external hackers attaching to SQL I have to use filtering on a
>firewall/router - not ideal, really should be able to switch it off at the
>server.
>
>Does anyone know if SQL can be told which IP's to listen on ?
>
>Alternatively if there are any MS dude's reading this, please please please
>fix it so I can control IP listening.
>
>I come from an OpenVMS/Sybase background where everything was infinitely
>configurable. Old version of Sybase allowed me to specify which IP's to
>listen on, regardless of O/S
>
>I'm still getting used to how open Windows is as an O/S, the emphasis seems
>to be on it being fully open first and not closed. (Everyone group for
>example)
>
>Cheers
>Simon
>
>

Relevant Pages

  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... listening on UDP 1434 using netstat -abn, ... And i double checked the connection string, and i did have it the right ... But I have another 2000 server that I can connect to fine, ... I am trying to connect from an XP SP2 machine remotely to a SQL Express ...
    (microsoft.public.sqlserver.connect)
  • Re: Server not listening on 1433
    ... Run the SQL "Server Network utility" and make sure that TCP/IP is ... > "SQL server listening on Shared Memory, ...
    (microsoft.public.sqlserver.setup)
  • Re: Server not listening on 1433
    ... sql server may be listening in a different port. ...
    (microsoft.public.sqlserver.setup)
  • SQL Server TCP/IP Listener Address
    ... I am currently setting up a SQL Server for a customer I have ... For example, the server is a multi-homed server with three NIC's, SQL ... insists on listening on all IP's on port 1433. ... to be on it being fully open first and not closed. ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)