RE: Usage Reporting via SQL Server
- From: Shijaz <Shijaz@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 2 Jul 2006 02:30:01 -0700
Hi Chris,
Just a thought:
Have you tried allowing the SQL protocol from your HR machines to your ISA
Server.
i.e:
Allow
Protocol: SQL Server (port 1433)
From: HR (computer/computer set)
To: Localhost
Users: All users
(or you could even make a user based rule allowing only HR "users" to
initiate SQL sessions to ISA - instead of the HR computer set - recommended
if your HR is on DHCP
Eg:
Allow
Protocol: SQL Server
From: internal
To: localhost
Users: HR Users (user set/group)
).
Hope this helps,
--
Shijaz
www.shijaz.com/isaserver
"Chris Mitfield" wrote:
Before I get to my issue, I thought I might share my config:.
I have a single ISA 2004 Enterprise server running on a dual CPU 2.4 Ghz
system with 4GB of RAM. The system is set to have an internal and external
interface. The internal interface is a hard coded 1GB Full connection. I have
this system publishing 6 internal webservers and am hosting an avg of 1800
total sessions.
The ISA server is logging to a SQL backend server which is a dual CPU 3Ghz
with 4GB of RAM and running SQL Server 2005.
Both systems are running Windows Server 2003 R2 with all patches applied for
both the OS and the applications (ISA and SQL).
And now on to my problem. We have an HR department here that wants to be
able to run reports on users at will to find out where they are going. We
have a web group that wants to run reports on who is hitting their sites. And
we have administrators who need to know how the server is doing. My intent
had been to use SQL Reporting Services to provide each of these groups access
the info they need via a web page and call it a day. Unfortunately the only
place that I can run queries is from ISA itself as ANY query I run against
the DB using TSQL no matter how restricted brings the DB to it's knees. What
is the ISA doing for it's queries to avoid this issue?
Thanks in advance for any help you can provide.
--
Chris Mitfield
- Next by Date: Configuration Storage Server on CSS
- Next by thread: Configuration Storage Server on CSS
- Index(es):
Relevant Pages
|
