Fix for ISA stall when ODBC data source is unavailable.
One weekend I had an ISA server failure due to the SQL server that
This gave me some problems since I couldn’t get in remotely
I found a way to have ISA reconfigure itself to use text logging
1. Reconfigure all three services in the Logs node to log to text
2. Start the registry editor (Regedit.exe) and export the following
Verify that you have a registry file on your c: drive called: txt-logs.reg
3. Configure all three services in the Logs node back to log to
4. Configure Invalid ODBC log credential alert in the Alerts node.
I tested this setup by all of a sudden just downing my SQL server.
Once the database server is again available I can reconfigure the
It might be a good idea to also send an e-mail alert in case this
The reconfiguration options based on alerts are endless when you
Hope this is a helpful little trick.
Jens Madsen - [email protected]
Xantech Corporation - www.xantech.com