RE: IIS and SQL through the firewall

From: Bryan Allerdice (
Date: 07/20/01

Hash: SHA1

My network has a webserver with multiple IP's that talks to a
database machine (not outside the firewall, but that isn't
important). It uses the primary IP. A quick NETSTAT showed that.

Whether you can force the client to use a specific IP to communicate
with a database server - I don't know. But you don't need to worry
about that, the primary IP is used, so let that through.

As I mentioned above, if you bring up a command prompt on the client
machine (after an ODBC connection to the database machine has been
made), and run the command "netstat -n", you'll see what IP on your
client is doing the talking.

(If anyone else on this list can answer the "force the client to use
a specific IP" question, share the answer!)


- -----Original Message-----
From: Donna MacLeod []
Sent: Thursday, July 19, 2001 4:03 PM
To: focus-ms (E-mail)
Subject: IIS and SQL through the firewall

Hi all,

Quick question: I want to open up a connection through our firewall
from an
IIS server with multiple IP's each mapped to individual webs to a SQL
on the other side. What I'm wondering is will the web server use
primary IP to make the connection to the SQL server? I only want to
the one IP through the firewall.



Version: PGPfreeware 7.0.3 for non-commercial use <>


Do You Yahoo!?
Get your free address at

Relevant Pages

  • RE: OWA page not displayed Outside
    ... Open ISA 2006 management console. ... Expand the server node and highlight 'Monitoring'. ... Click 'Configure Firewall Logging'. ... |> internal client as both the web proxy client and firewall client? ...
  • Re: Small business thinking about backing up data, having a server and 2-3 users - is SBS200
    ... is networked to the Master with a crossover network cable. ... Master on the Master PC and Client on the Slave pc. ... Since this machine is a server is should handle the requests ok ... Most real firewall appliances have HTTP and SMTP proxy services that allow ...
  • Re: ISA firewall block outgoing email.
    ... I cannot send/receive email to the POP3 account unless I turn off the firewall in the CEICW. ... (This server is behind a router so I felt the test was safe enough to turn off the firewall). ... As I said, there is no need to add a hole for port 110, If the ISA client is installed on the workstation, Outlook will deliver the email. ...
  • RE: VBScript: Remote Desktop Disconnected
    ... I have a client with the same exact scenario. ... Rdp via RWW works fine from ... On the SBS 2003 Server open the Server Management console. ... When navigating to the Firewall page, ...
  • Re: SBS VPN setup?
    ... And I'm reviewing if I need to do client notifications at that point. ... You purchase 2k3 PREMIUM and that comes with ISA to handle the firewall duties. ... SBS plugs into a switch with the other computers and the switch is plugged into a firewall appliance with 2-nics. ... To compare apples to apples, let us assume there is a network setup as I outlined above...and the firewall appliance is an ISA server, such as those available from Celestix. ...