You'll create a DSN on the local ISA Server. That DSN contains all the ODBC
configuration options necessary to connect to the SQL server of your choice
(including the server name).
What box do you have SQL Server installed on? Even if it is the same server
(which I wouldn't do) you'll need to create the DSN so that the ISA logging
configuration knows what box to log to.
t
----- "I may disapprove of what you say, but I will defend to the death your right to say it."
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 ------------------------------------------------------ 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: jim@xxxxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx
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: bhanson@xxxxxxxxxx To unsubscribe visit http://www.webelists.com/cgi/lyris.pl?enter=isalist Report abuse to listadmin@xxxxxxxxxxxxx
