[isalist] Re: isa 2004 logs

  • From: "Thor (Hammer of God)" <thor@xxxxxxxxxxxxxxx>
  • To: <isalist@xxxxxxxxxxxxx>
  • Date: Fri, 8 Feb 2008 08:49:32 -0800

MSDE is the "local" SQL engine.   While you could run the SQL service
manager and changed the default configuration from "shared memory"  also
enabling "TCP" as a server option in order to connect directly to the
engine for queries, I don't recommend doing that on your firewall.



If you don't want to configure ISA to log to a "real" SQL server, then
you have the option of stopping the SQL instance and copying the MDF
files over to another SQL server (SQL Express 2005 works great unless
you need a db bigger than 4g) and attach to the MDF file.



Then you can start the SQL engine back up and work "off-line" so to
speak.  You won't be able to copy them with the service running as all
the MDFs will be in use.



t



From: isalist-bounce@xxxxxxxxxxxxx [mailto:isalist-bounce@xxxxxxxxxxxxx]
On Behalf Of James May
Sent: Friday, February 08, 2008 8:30 AM
To: isalist@xxxxxxxxxxxxx
Subject: [isalist] isa 2004 logs



Hello,

I recently enabled logging to MSDE format on ISA 2004. I'm not familiar
with this type of file format can anyone help as to where I might find a
good program to view the contents or a how to article?



Thanks,



James May



Other related posts: