According to "User Guide for Cisco Secure Access Control System 5.2"
"Use this page to configure a remote database to which you can export the Monitoring & Report Viewer data. ACS exports data to this remote database at specified intervals. You can schedule the export job to be run once every 1, 2, 4, 6, 8, 12, or 24 hours. You can create custom reporting applications that interact with this remote database. ACS supports the following databases:
•Oracle SQL Developer
•Microsoft SQL Server 2005'
I will use MS SQL Server 2005, but I wonder if anyone use MS SQL 2008 for this function?
And there is a firewall between ACS and SQL Server.
Does anyone know what protocol should I open for the export?
Also, what kind of role for the SQL Server user should I create?