RE: Confused - ISA 2004 logging to SQL 2000 docs
- From: "Bret Hanson" <Bhanson@xxxxxxxxxx>
- To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
- Date: Fri, 13 Jan 2006 12:49:48 -0600
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
Other related posts:
