I have ISA 2004 on a WIN2003 Server. Everything worked fine on the initial install and setup. The reports were working as advertised, and an email alert with a link was being sent.
After discovering how fast the SQL database was going to fill, I created a new database on a seperate server (bigger hard-drive), created a new ODBC pointing in the right direction, and edited my logging parameters.
Since then, all reports are empty. I have verified that ISA is logging the data in the new database using the new ODBC. The summaries are being created on a daily basis, but they are empty.
Can anyone help with this? I have found very little documentation on the summary creator, or how to troubleshoot and test it.
I have a similar problem. When I installed my ISA server, I chose to log to MSDE. My logs were consuming alot of space int he default area so I went to the place that lets you pick your own location. It created new logs in the new location. I tried to just move all the old logs to the new area, but ISA server now only recognizes the logging that's taken place since I moved the destination. I'm unable to report on the previous data I've accumulated. I'm thinking that I need to load my old data into the new DB somehow, but I'm not sure how. ISA creates that MSDE database, but it doesn't give you any tools to manage the database does it? I wonder if it's better or easier just to use text files?
RE: Empty reports after enabling SQL logging in ISA 2004 - 10.Mar.2005 3:08:00 AM
I have this exact same problem, it seems that support for this product is non-existent. The logs seem to go into the database no problem since I can query the sql server and get statistics that way. I don't see why ISA can't pull the stats out now. I've configured permissions properly, and just installed SP1 but no luck.
RE: Empty reports after enabling SQL logging in ISA 2004 - 11.Mar.2005 2:20:00 AM
I've tried a few other thing but I still cannot get this working: - Removed MSDE from our ISA server - Repaired ISA installation - Disabled/re-Enabled logging - Removed old MSDE logs - Removed old ILS files I query our SQL server and it is actually storing information into it, it just seems that it is not pulling info out of it. Before I uninstalled MSDE, I noticed that if I looked up reports on days prior to logging to SQL server that the repors would generate for those days so I'm led to beleive that ISA is still trying to look at MSDE data. Now that it is uninstalled, I cannot pull up these old reports and it gives me an error. Trying to generate new reports does not give me an error but doesn't display data. Any help would be much appreciated Thanks!