OK-- I'm with you now... Other than the DSN thing, everything else should be
the same. Since you are using Windows Auth (which is good) just make sure
you create a logon for the machine names (like MYDOMAIN\ISA1$ and
MYDOMAIN\ISA2$) so that the machine authentication will work.
I should warn you, though... The default .sql script that comes with ISA
creates a table structure that is not efficient regarding storage space. Be
prepared for HUGE databases if you are logging any data of substance. I've
actually had to create a whole sub-structure to parse data and post it into
my own table design and delete "raw" data after a pre-defined time period.
You might also look at disabling "lock-down" mode, as ISA logging to SQL is
not tolerant of logging delays.
t
----- "I'll see your Llama and up you a Badger." John T
http://www.ISAserver.org
The Microsoft docs for setting up ISA04 to SQL don't work if you are running ISA 2004 Enterprise Edition. If I had more experience using SQL - maybe this would be a no brainer - but that ain't the case and I wanted to make sure I wasn't missing something.
Thanks, Bret
-----Original Message----- From: Thor (Hammer of God) [mailto:thor@xxxxxxxxxxxxxxx] Sent: Friday, January 13, 2006 12:15 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
SE servers can also share the same SQL DB, as can any SQL client... It just seems that rather than configuring a DSN for the connection, the EE logging configuration "directly" accesses the SQL box, which seems a bit surprising, but is obviously the case.
But not withstanding the difference in DSN/direct config, what is the actual issue here? What doesn't work?
t
----- "I'll see your Llama and up you a Badger." John T
----- Original Message ----- From: "Jim Harrison" <Jim@xxxxxxxxxxxx> To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx> Sent: Friday, January 13, 2006 9:16 AM Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
Yeh - I got that - ISA 2000 doesn't have a "monitoring" tab. You're right though; that was for SE, not EE.
Because EE servers can share a single DB, they dropped the DSN mechanism. What this means is that you can point all your array members to the same SQL SB.
Send mail to isadocs@xxxxxxxxxxxxx with your comments.
------------------------------------------------------- Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/Jim_Harrison/ http://isatools.org Read the help / books / articles! -------------------------------------------------------
-----Original Message----- From: Bret Hanson [mailto:Bhanson@xxxxxxxxxx] Sent: Friday, January 13, 2006 08:22 To: [ISAserver.org Discussion List] Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
There is no ODBC data source (DSN) box, this is what I get: http://ftp.yunker.com/isa/isa.jpg
As stated before this is a ISA 2004EE - not an ISA 2000 install. No problems finding where to enter ODBC information in the ISA 2000 install.
Thanks, Bret
-----Original Message----- From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx] Sent: Thursday, January 12, 2006 4:38 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
It's part of the <service> logging properties dialog. If you: - Open the ISA manglement cornsoul - expand <ArrayName> - select "Monitoring" - select the "Logging" tab - in the "Task" pane on the right, click "Configure <service> Logging"
Ta-daa...
-------------------------------------------- Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/Jim_Harrison/ http://isatools.org Read the help / books / articles! --------------------------------------------
-----Original Message----- From: Bret Hanson [mailto:Bhanson@xxxxxxxxxx] Sent: Thursday, January 12, 2006 2:06 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
That I know. What is puzzling me is why in Microsoft's documentation (article 838710) for logging ISA 04 to a SQL 2000 it says to "type the DSN
in the ODBC data source (DSN) box."
There is no such box on my ISA 2004EE install - unless I am just a dumba-- which is possible.
Thanks
-----Original Message----- From: Jim Harrison [mailto:Jim@xxxxxxxxxxxx] Sent: Thursday, January 12, 2006 3:41 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
ODBC and DSN configurations are part of "Administrative Tools", "Data Sources".
-------------------------------------------- Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/Jim_Harrison/ http://isatools.org Read the help / books / articles! --------------------------------------------
-----Original Message----- From: Bret Hanson [mailto:Bhanson@xxxxxxxxxx] Sent: Thursday, January 12, 2006 8:55 AM To: [ISAserver.org Discussion List] Subject: [isalist] Confused - ISA 2004 logging to SQL 2000 docs
http://www.ISAserver.org
We have a ISA 2004EE box on our test network and would like to log to a SQL 2000 database. However, Microsoft's article 838710 in the "How to configure ISA Server 2004 to log information to an SQL Server database" section, line six refers to a "ODBC data source (DSN) box." This box does
not exist in my installation (under Firewall logging > options). I have boxes to enter a server, port, database, table, user and password.
Oddly enough, Tom's ISA 2004 book (pg 981) also refers to using ODBC data sources when configuring ISA to log to a SQL Server.
I have little experience with SQL and databases in general so I may be just confusing terminology. Could someone help clear this up? Do I even need to create a DSN? Im a bit confused.
Thanks, Bret
All mail to and from this domain is GFI-scanned.
------------------------------------------------------ List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ ------------------------------------------------------ Visit TechGenix.com for more information about our other sites: http://www.techgenix.com ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: thor@xxxxxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx
------------------------------------------------------ List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ ------------------------------------------------------ Visit TechGenix.com for more information about our other sites: http://www.techgenix.com ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: bhanson@xxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx