Re: ISA 2k4 firewall service failure on reboot

Make sure you're not trying to keep more than 7 days' worth of logs.
MSDE can only service 8 simultaneous connections and if you have more than 7
active databases, MSDE will churn through connect / disconnect / reconnect
in order to serve those additional requests.
This can cause MSDE startup to take longer than fwsrv can wait.

--
Jim Harrison (ISA SE)

This posting implies no warranty and confers no rights.
http://catb.org/~esr/faqs/smart-questions.html



"Chris" <Chris@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E4BB3F70-7545-42BC-A2E0-5E48628DE866@xxxxxxxxxxxxxxxx
Hi,

Whenever I restart our ISA Server 2004 SP3 (win2k3 sp1) the firewall service
will not start automatically.

The error logs have only the following errors:
a) Event ID 14001
Firewall Service failed to initialize. Previous event log entries might help
determine the proper action.
b) Event ID 21192
The Microsoft Firewall was unable to connect to MSDE database. The MSDE
Error description is: Could not find database ID 110. Database may not be
activated yet or may be in transition., Multiple-step OLE DB operation
generated errors. Check each OLE DB status value, if available. No work was
done., Property value is invalid. Make sure the value is typed correctly..


After logging in the firewall service can be started successfully through
the management console without having to do anything else.

This server is usually remotely managed and having to log on physically
after a reboot to start the firewall service is not an option I have all the
time.

regards,
Chris

.

Relevant Pages

  • Re: ISA 2004 / MSDE Error Logging - bug?
    ... I thought that was a MSDE issue. ... > What you're seeing is the difference between what MSDE supports vs. what you have configured in ISA. ... ISA generates at least 2 log databases; more if your ISA handles lots of traffic. ... > I know these logs relate to SQL rather than the ISA log data. ...
    (microsoft.public.isa)
  • Re: ISA 2k4 firewall service failure on reboot
    ... I am indeed keeping more than 7 days of logs, ... MSDE can only service 8 simultaneous connections and if you have more than ... The Microsoft Firewall was unable to connect to MSDE database. ... After logging in the firewall service can be started successfully through ...
    (microsoft.public.isaserver)
  • RE: ISA 2004 / MSDE Error Logging - bug?
    ... I know these logs relate to SQL (MSDE) rather than the ISA log data. ... you can choose to logging into text file instead of databases. ...
    (microsoft.public.isa)
  • Re: ISA 2004 / MSDE Error Logging - bug?
    ... What you're seeing is the difference between what MSDE supports vs. what you have configured in ISA. ... ISA generates at least 2 log databases; more if your ISA handles lots of traffic. ... I know these logs relate to SQL rather than the ISA log data. ...
    (microsoft.public.isa)
  • How to Delay ISA2004 Startup for Firewall?
    ... How can we delay the startup of ISA2004 to force it to wait for MSDE to ... "The Microsoft Firewall was unable to connect to MSDE database. ... I am force to manually login and start the firewall service. ...
    (microsoft.public.isa)
Loading