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

1. Open the NPS console or the NPS Microsoft Management Console (MMC) snap-in.

2. In the console tree, click Accounting.

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

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

   1. To log all accounting requests, click Accounting requests.
      
      
   2. To log authentication requests, click Authentication requests.
      
      
   3. To log periodic accounting status, click Periodic accounting status.
      
      
   4. 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, type a number in Maximum number of concurrent sessions.

6. To configure the SQL Server data source, in SQL Server Logging, 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 NPS and SQL Server, click Test Connection.