none
Network Policy Server: SQL Server Logging configuration RRS feed

  • Question

  • Hi,

    In NPS there is an option to configure SQL SRV accounting. Since I have 0 clues about the machinery of SQL SRV I was wondering what additional configuration one needs to do on SQL SRV. Some screenshots to help understanding the issue.

    Pic 1:

    Pic 2:

    Pic 3

    And this 3rd pic is most intriguing. What additional work one need to do on SQL SRV? "Select database on the server"- how do you get/create one???

    To make the matter even more interesting NPS offers us the mix of SQL database and text file plus failover. Any light on this matter?

    Any clues/articles much appreciated!!!

    Monday, May 27, 2019 1:52 PM

Answers

  • Hi InfoTechdude,

    >>"Select database on the server"- how do you get/create one???

    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.

    >> NPS offers us the mix of SQL database and text file plus failover

    SQL logging only. By using this setting, you can configure a data link to a SQL Server that allows NPS to connect to and send accounting data to the SQL server. In addition, the wizard can configure the database on the SQL Server to ensure that the database is compatible with NPS SQL server logging.

    Text logging only. By using this setting, you can configure NPS to log accounting data to a text file.

    Both SQL Server logging and text logging allow you to specify whether NPS continues to process connection requests if logging fails. You can specify this in the Logging failure action section in local file logging properties, in SQL server logging properties, and while you are running the Accounting Configuration Wizard.

    Please refer to Configure Network Policy Server Accounting to get more information.

    Best regards,
    Cathy Ji


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Tuesday, May 28, 2019 7:07 AM

All replies