2012 R2 NPS SQL Logging

[ITGURU]

Hi

I have a fully working NPS server which is working logging to a local text file. However, for long term storage I'm looking to also store the data into a SQL database table so can carry out easier searches.

 

However, I've found several guides online, SQL scripts etc to create the tables etc but none seem to be working successfully. I've had it create the table fields but not inserting any data.

 

Has anyone set this up or got a working step by step to help me please.

 

Thanks.

[ITGURU]

Can anyone shed any light on this for me please? Does no one log NPS to SQL ,only the text files??

[jamesfed]

https://msdn.microsoft.com/en-us/library/bb960723(VS.85).aspx is what you are looking for to make the tables

[ITGURU]

https://msdn.microsoft.com/en-us/library/bb960723(VS.85).aspx is what you are looking for to make the tables

 

Thanks I tried that initially, then I used the NPS accounting log wizard which created the table also, but no data appears to be transferring still.

[jamesfed]

Firewall port for SQL Server open?

[ITGURU]

Firewall port for SQL Server open?

 

Should be as other servers can communicate with the sql server..

[ITGURU]

Managed to resolve this - despite the NPS server connection to SQL saying the test was successful it was to do with the SQL database. I was trying to point the NPS server to my HP SIM server which I use for all central monitoring, SYSLOG, server events etc, but seems the SQL server wouldnt accept connection from a remote system.

 

I re-ran the NPS accounting wizard, pointed it to an SQL server I set up from scratch and it worked first time and is now recording data.

 

The joys of IT!

[ITGURU]

Although the data now appears to be transferring I've noticed that not ALL fields are included. Within the server NPS logs there is both entries for Call Station identifier and Calling Station identifier. One to log the source AP and WiFi name, the other the client mac address.

 

However, within SQL it only logs the WIFI AP MAC address, not the client. The idea would be to track a client MAc address to see where it has connected but obviously defeats the object I was looking for.

[jamesfed]

What wireless hardware are you using? Some report things (extra attributes and suchlike) differently to others....