VPN Logs

[Brian]

I am running Windows 2003 Standard. I have RRAS
installed. In the logging section there is an option to
have the log files put into a SQL database. From what I
can tell you have to create the database yourself. Is
this correct?

The only problem I have with creating the database is how
to name the fields in the table. I looked at the logfile
in %systemroot%\system32\logfiles. It is a comma
separated file but I have no idea what each field
represents.

anybody have any ideas or can point me to some articles
on this.

thanks in advance,
Brian

 

[Srivatsan [MSFT]]

Check the following pointers:

Name and data type of the contents of the log file are
http://www.microsoft.com/resources/...003/standard/proddocs/en-us/sag_ias_log1a.asp
How to configure the sql server for ias logs @
http://support.microsoft.com/default.aspx?scid=kb;en-us;323723

How the actual logging happens @
http://www.microsoft.com/resources/...3/standard/proddocs/en-us/sag_ias_log_sql.asp

Hope this helps.