Re: AW: logging to a database - anyone do it?
- From: "DBA From Hell" <alecw@xxxxxxx>
- To: isalist@xxxxxxxxxxxxx
- Date: Tue, 29 Jan 2002 09:24:40 -0700
SQL Server is a superior way of storing the ISA logs, but make sure you
have the disk space. If you're not so concerned with real-time logging,
you might also want to schedule a DTS Package to populate the log tables
with the text based logs. The text logs are very readily shippable to SQL
Server. To create the database, just create a new blank DB in SQL server
and to create the tables use the three SQL scripts that come with the ISA
Server install disks in the Support folder. There is one for each
available log in ISA.
When you create the ODBC connection required to write the logs to SQL
Server, make sure to use a System ODBC connection (the second tab in ODBC)
rather than a User Connection. Trying to connect with a User ODBC will
create unspeakable havoc. Good luck!
> > This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
>
> --B_3094726207_160640
> Content-type: text/plain; charset="US-ASCII"
> Content-transfer-encoding: 7bit
>
> OK, do you have any pointers to information about setting this kind of thing
> up? I have a SQL 2000 server running, and would love to look at reports
> using something other than browsing through text files. This sounds like
> just the thing.
>
> Thanks,
>
>
> Ian Sterling
>
>
> On 1/23/02 1:00 AM, "Krause, Martin" <MKrause@xxxxxxxxxxxxxxxxxxxxxxxx>
> wrote:
>
> > http://www.ISAserver.org
> >
> > hi alexander , i run a sql server database behind isa and call them via asp
> > .
> > i have no problems
> >
> > martin
>
>
>
> --B_3094726207_160640
> Content-type: text/html; charset="US-ASCII"
> Content-transfer-encoding: quoted-printable
>
> <HTML>
> <HEAD>
> <TITLE>Re: [isalist] AW: logging to a database - anyone do it?</TITLE>
> </HEAD>
> <BODY>
> <FONT FACE=3D"Verdana">OK, do you have any pointers to information about sett=
> ing this kind of thing up? I have a SQL 2000 server running, and would=
> love to look at reports using something other than browsing through text fi=
> les. This sounds like just the thing. <BR>
> <BR>
> Thanks,<BR>
> <BR>
> <BR>
> Ian Sterling<BR>
> <BR>
> <BR>
> On 1/23/02 1:00 AM, "Krause, Martin" <MKrause@schulz-elektrote=
> chnik.de> wrote:<BR>
> <BR>
> </FONT><BLOCKQUOTE><FONT FACE=3D"Verdana">http://www.ISAserver.org<BR>
> <BR>
> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT FACE=3D"Arial">hi
> alexander=
> , i run a sql server database behind isa and call them via asp . i have no =
> problems <BR>
> </FONT></FONT></FONT><FONT FACE=3D"Verdana"> <BR>
> </FONT><FONT COLOR=3D"#0000FF"><FONT SIZE=3D"2"><FONT
> FACE=3D"Arial">martin<BR>
> </FONT></FONT></FONT></BLOCKQUOTE><FONT FACE=3D"Verdana"><BR>
> </FONT>
> </BODY>
> </HTML>
>
>
> --B_3094726207_160640--
Other related posts:
