Welcome to ISAserver.org

IIS6 through ISA 2004 and SQL reporting issue

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA Server 2004 General ] >> Web Publishing >> IIS6 through ISA 2004 and SQL reporting issue

Page: [1]

Message

<< Older Topic Newer Topic >>

IIS6 through ISA 2004 and SQL reporting issue - 10.Nov.2005 11:57:09 PM

zetone

Posts: 12
Joined: 10.Nov.2005
From: Romania
Status: offline

First of all, hello to everybody.

It's been almost 1 year since I first start using guides and articles from this site. Today I've joined this forum.

Here is my first ISA/IIS problem that I could not get it fixed.

I have several sites published on my IIS6 machine. All of those sites are configured to report usage into SQL2K database. All sites are published through ISA2004 (which resides on the same machine as IIS6) using the same web publishing rule with several entries in the public name corresponding to each site.

Now, the problem: although the "forward the original host header..." & "request appear to come from the original client" are selected, I can only see the IP of the ISA server external interface accessing the sites. The "clienthost" entry in SQL IIS table only shows 1 IP.

I've tried playing with the server name (from the publishing rule). I set the server address as the internal IP interface, the external interface, even entered the internal server FQDN. Also tried to play with the IP address assignment in IIS6.

All the above with no success. Still got a single entry in the "cleinthost" field.

In the same time, the reporting of IP addresses accessing the FTP server (located on the same server) works fine.

I'm open to any suggestions.

Have a nice weekend,

_____________________________

Cheers,
Dragos

Post #: 1

Featured Links*

RE: IIS6 through ISA 2004 and SQL reporting issue - 11.Nov.2005 5:11:18 PM

tshinder

Posts: 47490
Joined: 10.Jan.2001
From: Texas
Status: offline

Hi Dragos,

The ISA firewall really want designed to be used that way. For example, you don't install IIS on PIX or Netscreen firewalls, you don't install it on ISA firewalls.

Put the ISA firewall, in full firewall mode (multiple interfaces) and configure the rule to preserve the source IP address.

HTH,
Tom

_____________________________

Thomas W Shinder, M.D.
Sr. Consultant/Technical Writer
Prowess Consulting http://www.prowessconsulting.com/
Blog: http://blogs.isaserver.org/shinder/

GET THE NEW ISA 2006 Book!: http://tinyurl.com/2gpoo8

(in reply to zetone)

Post #: 2