Re: Authenticate and Billing.

From: FenderAxe (fa_at_axe.com)
Date: 03/09/05 

Date: 9 Mar 2005 07:05:47 GMT

"Thomas K" <thomas@kuborn.be> wrote in
news:422cb4fd$0$44062$5fc3050@dreader2.news.tiscali.nl:

> Hey,
>
> How you correlate authentication events (who? / when?) & accounting
> events (how much?)
>
> /T
>
> "Mark Gamache" <mark.gamache@css-security.com.nospam> wrote in message
> news:#O7eNh0IFHA.3916@TK2MSFTNGP14.phx.gbl...
>> IAS logs are pretty easy to parse for billing related data. Your NAS
>> type defines just what data and how much is returned. Most NASs will
>> return
> data
>> related to bytes in and out. The authentication process will
>> generate who and when data.
>>
>> Cheers,
>>
>>
>> --
>> Mark Gamache
>> Certified Security Solutions
>> http://www.css-security.com
>>
>>
>>
>> "Herman" <herman_d@hotmail.com> wrote in message
>> news:522a01c522f4$87310af0$a401280a@phx.gbl...
>> > Dear All,
>> >
>> > Does IAS can be used for Hotspot Billing ?
>> > How do I manage user account ?
>> > And also their billing management ?
>>
>>
>
>
You can find all the logging info you need in this whitepaper: Deploying
SQL Server Logging with Windows Server 2003 Internet Authentication Service
(IAS)

http://www.microsoft.com/downloads/details.aspx?FamilyId=6E4357F7-4070-
4902-95F1-3AD411D963B2&displaylang=en

The info is the same no matter what logging format you choose, far's I
know.

>From that paper:

Required database fields for session correlation

When you create the fields in the tables of your MSDE 2000 and SQL Server
databases, you must provide all fields that allow applications to query the
database, correlate related fields, and return a cohesive view of each
session in the query results. This is called session correlation. At a
minimum, to provide session correlation, you must log the following IAS
accounting data in the MSDE 2000 and SQL Server 2000 databases:
" NAS-IP-Address
" NAS-Identifier (You need both NAS-IP-Address and NAS-Identifier
because the network access server, or NAS, can send one or the other.)
" Class
" Acct-Session-Id
" Acct-Multi-Session-Id
" Packet-Type
" Acct-Status-Type
" Acct-Interim-Interval
" NAS-Port
" Event-Timestamp

x-- 100 Proof News - http://www.100ProofNews.com
x-- 3,500+ Binary NewsGroups, and over 90,000 other groups
x-- Access to over 1 Terabyte per Day - $8.95/Month
x-- UNLIMITED DOWNLOAD

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Word 2003/Access2000/SQLSVR
    ... SQL server being where the data is held and this is accessed through a MS ... entire database and that may be say a record for Berkshire. ... "Peter Jamieson" wrote: ... replaced with the first record on the table in use. ...
    (microsoft.public.word.mailmerge.fields)