RE: SQL Logging

  • From: "Vinay, G (ICRISAT-IN)" <g.vinay@xxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Thu, 29 May 2003 22:26:37 -0700

HI shawn,
         ISA is logging to text files, and also to SQL, which i have
installed on ISA box. Can i get some precise field
which is creating the problem. I am trying to implement the same mentioned
by u.

Regards,
Vinay.

-----Original Message-----
From: Quillman Shawn (RBNA/CIT1.1) *
[mailto:Shawn.Quillman@xxxxxxxxxxxx]
Sent: Thursday, May 29, 2003 5:49 PM
To: [ISAserver.org Discussion List]
Subject: [isalist] RE: SQL Logging


http://www.ISAserver.org



Did you mean that ISA will only log to local text files or do you have SQL
on your ISA box?  I seem to remember an error in the SQL script for creating
the web proxy log table on the ISA distribution.  There was a field that was
defined improperly.  I can't remember, I will go back and look.

Something you can try is taking one of your text logs and importing it into
SQL to make sure the table definitions are correct.  If that works then you
need to make sure ODBC is configured correctly for your envrionment.

-Shawn

-----
Shawn R. Quillman
Robert Bosch Corporation RBNA/CIT1.1
38000 Hills Tech Drive
Farmington Hills, MI  48331
(248) 553-1164 (P)     (248) 848-2855 (F)
shawn.quillman@xxxxxxxxxxxx


-----Original Message-----
From: Vinay, G (ICRISAT-IN) [mailto:g.vinay@xxxxxxxxx]
Sent: Thursday, May 29, 2003 4:13 AM
To: [ISAserver.org Discussion List]
Subject: [isalist] SQL Logging


http://www.ISAserver.org



Hi All,
       I want to log the webproxy requests in SQL database instead of a text
file on ISA. I tried the option, but
ISA is logging in only on local SQL database, where as the webproxy service
does not start, if i try to log the requests
to remote sql database on some other machine. ANyone has some idea of this?
Please advice.


Regards,
Vinay.
MCSE,CCNA.   

------------------------------------------------------
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
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
shawn.quillman@xxxxxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')

------------------------------------------------------
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
------------------------------------------------------
Other Internet Software Marketing Sites:
Leading Network Software Directory: http://www.serverfiles.com
No.1 Exchange Server Resource Site: http://www.msexchange.org
Windows Security Resource Site: http://www.windowsecurity.com/
Network Security Library: http://www.secinf.net/
Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
------------------------------------------------------
You are currently subscribed to this ISAserver.org Discussion List as:
g.vinay@xxxxxxxxx
To unsubscribe send a blank email to $subst('Email.Unsub')


Other related posts: