ISA Services do not start if they are unable to log to the database

View products that this article applies to.

Symptoms

When your ISA Server is configured to log to an ODBC database, one or more of the ISA services may not start, and the following errors may be recorded in the Application Event log.

If the Microsoft Firewall Service Did Not Start

System Log:
===========
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft Firewall service terminated with service-specific error 212994.

Application Log:
================
Event Type: Error
Event Source: Microsoft Firewall
Event Category: Log
Event ID: 2
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft Firewall was unable to open ODBC Data Source firewall, Table: Table1, under User Name administrator name. The ODBC Error description is: The operation completed successfully. For more information about this event, see ISA Server Help.

If the Microsoft Web Proxy Service Did Not Start

System Log:
===========
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7024
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft Web Proxy service terminated with service-specific error 2147942406.

Application Log:
================
Event Type: Error
Event Source: Microsoft Web Proxy
Event Category: Log
Event ID: 2
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft Web Proxy was unable to open ODBC Data Source web, Table: Table1, under User Name []. The ODBC Error description is: Overlapped I/O operation is in progress. For more information about this event, see ISA Server Help.

If the Microsoft ISA Server Control Service Did Not Start

System Log:
===========
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7023
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft ISA Server Control service terminated with the following error: The handle is invalid.

Application Log:
================
Event Type: Error
Event Source: Microsoft ISA Server Control
Event Category: Log
Event ID: 2
Date: date
Time: time
User: N/A
Computer: computer name
Description: The Microsoft ISA Server Control was unable to open ODBC Data Source web, Table: Table1, under User Name []. The ODBC Error description is: Overlapped I/O operation is in progress. For more information about this event, see ISA Server Help.

↑ Back to the top

Cause

This issue can occur if the ISA service cannot log to the database. Services do not start if they are unable to log to the data base.

↑ Back to the top

Resolution

To resolve this issue, verify that the ODBC DSN is configured correctly and the database is accessible:

In the ISA Management MMC, expand the ISA Server computer, expand "Monitoring Configuration," and then click Logs. The "Packet Filters" component corresponds to the "Microsoft ISA Server Control service". The "ISA Server Firewall service" corresponds to the "Microsoft Firewall" service. The "ISA Server Web Proxy Service" corresponds to the "Microsoft Web Proxy" service.
Right-click the appropriate component, and then click Properties. Verify that the Database section is using a valid DSN, and that the DSN is set up correctly.
Verify that the Use this account box contains a valid database account, that is, a Windows NT account that has permissions to log on to the database.

NOTE: Although the Use this accountoption is necessary if you are using Microsoft Windows NT authentication in the DSN, you do not have to fill out the Use this account box with a user name and password

For additional information about how to set up ISA Server to log to an SQL database, click the following article number to view the article in the Microsoft Knowledge Base:

300211 How to configure ISA Server 2000 to log on to a SQL Server database

↑ Back to the top