RE: Confused - ISA 2004 logging to SQL 2000 docs - isalist

RE: Confused - ISA 2004 logging to SQL 2000 docs

From: "Thor \(Hammer of God\)" <thor@xxxxxxxxxxxxxxx>
To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
Date: Fri, 13 Jan 2006 10:14:32 -0800

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?

-----
"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

RE: Confused - ISA 2004 logging to SQL 2000 docs

Other related posts: