Microsoft KB Archive/300215

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

Article ID: 300215

Article Last Modified on 10/31/2006

-

APPLIES TO


 * Microsoft Internet Security and Acceleration Server 2000 Standard Edition

-



This article was previously published under Q300215



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.



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.



RESOLUTION
To resolve this issue, verify that the ODBC DSN is configured correctly and the database is accessible:
 * 1) In the ISA Management MMC, expand the ISA Server computer, expand &quot;Monitoring Configuration,&quot; and then click Logs. The &quot;Packet Filters&quot; component corresponds to the &quot;Microsoft ISA Server Control service&quot;. The &quot;ISA Server Firewall service&quot; corresponds to the &quot;Microsoft Firewall&quot; service. The &quot;ISA Server Web Proxy Service&quot; corresponds to the &quot;Microsoft Web Proxy&quot; service.
 * 2) 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.
 * 3) 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

Keywords: kbenv kberrmsg kbprb KB300215

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.