Configure SQL Server Logging in NPS

Applies To: Windows Server 2008

Use this procedure to log RADIUS accounting data to a local or remote database running Microsoft® SQL Server™.

Configure SQL Server logging in NPS

You can configure Network Policy Server (NPS) to perform RADIUS accounting for user authentication requests, Access-Accept messages, Access-Reject messages, accounting requests and responses, and periodic status updates. You can use this procedure to configure logging properties and the connection to the server running SQL Server that stores your accounting data.

Note

NPS formats accounting data as an XML document that it sends to the report_event stored procedure in the SQL Server database that you designate in NPS. For SQL Server logging to function properly, you must have a stored procedure named report_event in the SQL Server database that can receive and parse the XML documents from NPS.

Membership in Domain Admins, or equivalent, is the minimum required to complete this procedure.

To configure SQL Server logging in NPS using the Windows interface

  1. Open the Network Policy Server MMC snap-in.

  2. In the console tree, click Accounting.

  3. In the details pane, in SQL Server Logging, click Configure SQL Server Logging. The SQL Server Logging dialog box opens.

  4. In Log the following information, select the information that you want to log:

    • To log all accounting requests, click Accounting requests.

    • To log authentication requests, click Authentication requests.

    • To log periodic status, such as interim accounting requests, click Periodic status.

  5. To configure the number of concurrent sessions allowed between the server running NPS and the SQL Server database, type a number in Maximum number of concurrent sessions.

  6. To configure the SQL Server data source, click Configure. The Data Link Properties dialog box opens. On the Connection tab, specify the following:

    • To specify the name of the server on which the database is stored, type or select a name in Select or enter a server name.

    • To specify the authentication method with which to log on to the server, click Use Windows NT integrated security. Or, click Use a specific user name and password, and then type credentials in User name and Password.

    • To allow a blank password, click Blank password.

    • To store the password, click Allow saving password.

    • To specify which database to connect to on the computer running SQL Server, click Select the database on the server, and then select a database name from the list.

  7. To test the connection between the server running NPS and the computer running SQL Server, click Test Connection.