I'm configuring NPS on a Windows Server 2008 R2 Enterprise, and want to log all RADIUS accounting info to SQL. My SQL Admin needs to know the size of the database to create for this. What size is recommended? Our NPS grants access to Cisco device IOS (for 3-4 users), Cisco VPN (300 users, average of 10 VPN sessions per day), and Cisco Wireless APs (300 users, average 30-40 wireless access requests per day).

On Thu, 2 Jun 2011 14:27:52 +0000, Bohde8781 wrote: My SQL Admin needs to know the size of the database to create for this.? What size is recommended? > Our NPS grants access to Cisco device IOS (for 3-4 users), Cisco VPN (300 users, average of 10 VPN sessions per day), and Cisco Wireless APs (300 users, average 30-40 wireless access requests per day). http://ing.ctit.utwente.nl/WU5/D5.1/Technology/radius Not a sizing recommendation but does a good job of describing the process, and provides a formula for determining the message size. Paul Adare MVP - Identity Lifecycle Manager http://www.identit.ca Never trust a computer you can't lift. -- Stan Masor