Windows 2003 rras and SQL logging

[jeneric13]

I have a windows 2003 server setup for modem and vpn connections, I set
it to log to a sql server. I have configured everything to log
correctly and it all works.
So I am comparing the data to what I receive in system logs and it does
not add up. The sql logs do not contain disconnect time, time
connected nor IP address assigned. Which I would think is fairly
important info. The sql logs do give source IP address and connecting
computer name which is great but I also need to tie in the
aformentioned info or the whole thing is worthless to me.
I cannot find any additional options for this any suggestions would be
appreciated....

 

[Priya Raghavan [MSFT]]

Hi,

To extract the info which you require, you can use these steps:

Time connected:
When the client connects to the RAS Server, the accounting logs will
show an Access-Request and Access-Accept info. You can save the time when
the client connects.
When the client disconnects from the RAS Server, the accounting logs
will show an Accounting Stop info. You can save the time when the client
disconnects.
The difference between them is the interval for which the client was
connected.

Disconnect time:
When the client disconnects, it records an Accounting Stop info. It also
displays the time when it received the Accounting Stop info. From this you
can get the disconnect time.

IP address assigned to the client:
I am not sure if this can be obtained from the accounting logs.