Welcome to ISAserver.org

Logging to SQL with Load Balanced ISA

Users viewing this topic: none

Logged in as: Guest

Printable Version

All Forums >> [ISA 2006 Firewall] >> Logging and Reporting >> Logging to SQL with Load Balanced ISA

Page: [1]

Message

<< Older Topic Newer Topic >>

Logging to SQL with Load Balanced ISA - 7.Nov.2007 2:30:31 PM

cnsrvative

Posts: 14
Joined: 1.Sep.2004
From: Denver, Co
Status: offline

Have implemented 2 load balanced ISA servers, and set up actually went pretty well. The final portion of the setup was to confirm logging was being done the way we wanted. However, we get an error on the logging on one of the servers, and the information I have found through MS does not help.

Initial configuration was logging to the MSDE database on the server. We have since migrated to using a SQL database - the same error occurs regardless of where the logging database is stored.

The error is:
"The query stopped because an error occurred while it was running."

I get this error when going to |Arrays|LocalArray|Monitoring - Logging tab, and click on START QUERY - but only on ONE of the servers (the configuration store server).

On the other server, this function works.

MS article I found on the error:
http://www.microsoft.com/technet/isa/2004/plan/tb_logging.mspx#QueryStoppedDuetoError

User has db_datareader, db_datawriter GRANT permissions on the DB, as well as GRANT permissions on the store procedures in the DB.

Another thing I have noticed, is that the dashboard only displays on the server where the logging query works. It does not display on the configuration store server (although there is no error, just a blank page.)

The only errors in the application log are related to a publishing rule (it has a port sharing conflict that I know about) and there are no errors in the system log.

Any help would be appreciated...

S