Re: Restrict IP connections

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Karl Gram (NOSPAMkarl_at_gramonline.nl)
Date: 03/27/04 

Date: Sat, 27 Mar 2004 22:09:13 +0100

Hi Dave,

As far as I know that's not possible. Your best option is probably to close
ports 1433 and 1434 on your firewall. These are the default ports SQL Server
listens on. If you changed the ports, you of course need to close these. If
you're running on Windows 2003, you can restrict IP's on the network level. 

-- 
Karl Gram, BSc, MBA
http://www.gramonline.com
"Dave Navarro" <dave@dave.dave> wrote in message
news:MPG.1acfa74cf9ba4b9a9897d5@news-40.giganews.com...
> I need to modify SQL Server 2000 Enterprise Edition so that it only
> listens on the two local IP addresses, not the IP address of the
> Internet.
>
> I found KB article Q244980, but the "Maintain a Virtual Server for
> Failover Clustering" can be selected.
>
> Is there a registry setting or something where I can set which IP's SQL
> server listens on?
>
> --Dave

Relevant Pages

  • Re: Cant replicate between two servers
    ... yes i check to ports in the firewall and it's all opened ... Ping only ... > appropriate permissions to access SQL Server and of course, the ports must ...
    (microsoft.public.sqlserver.replication)
  • Re: SQL Server Specific Windows Firewall Exception
    ... their network (and I'm not talking ZoneAlarm, McAfee Personal Firewall, here. ... Microsoft don't have a problem with it considering the exceptions ... Windows Firewall to enable remote access and administration to a SQL Server ... So, if we put aside the whole automatic open ports distraction, wouldn't it ...
    (microsoft.public.sqlserver.connect)
  • Re: Stateful Packet Inspection Firewall
    ... > I just got a DSL Router which includes an SPI firewall. ... > ports but also controls which applications can access the net / listen ... > and listens on port 400 for portscans, ...
    (comp.security.firewalls)
  • 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)