This Rule generates alerts when The ISA Server Web Filter was unable to connect to the MSDE database
The Firewall service generates this alert when the OLEDB connection object could not be opened. The OLEDB connection is used by the Firewall service to insert records to the SQL database. The first parameter of the alert contains the name of the logging component (Firewall or Web Proxy). The second parameter of the alert contains the error description received from SQL.
Opening OLEDB connection can fail under the following circumstances:
The service does not have appropriate permission.
Low resources on the computer.
The specified SQL server does not exist.
The SQL service (MSSQL) is not started on the SQL server.
There is a connectivity problem to the SQL server.
Authentication to the SQL server failed.
The specified database or table does not exist on the SQL server.
SQL server does not support encryption.
Close other programs that are running. Use the Task Manager to check programs and processes using large amounts of system resources.
Verify that the specified SQL server;is accessible.
Start MSSQL service on the SQL server.
Verify that the specified database and table exist on the SQL server.
Enable SSL encryption on the SQL server.
Change the provided user credentials.
Add a firewall policy rule that allows traffic to the SQL server.
For more information about ISA Server logs, refer to the "Logs" topic in the ISA Server on-line help.
| Target | Microsoft.ISAServer.2006.Logging.Advanced |
| Category | EventCollection |
| Enabled | True |
| Alert Generate | False |
| Remotable | True |
| ID | Module Type | TypeId | RunAs |
|---|---|---|---|
| DS | DataSource | Microsoft.ISAServer.2006.Rule.AlertGenerate.DS | Default |
| WA | WriteAction | Microsoft.ISAServer.2006.Rule.AlertGenerate.WA | Default |
Home<Rule ID="Microsoft.ISAServer.2006.The_ISA_Server_Web_Filter_was_unable_to_connect_to_the_MSDE_database.Rule" Enabled="onEssentialMonitoring" Target="Microsoft.ISAServer.2006.Logging.Advanced" ConfirmDelivery="true" Remotable="true" Priority="Normal" DiscardLevel="100">
<Category>EventCollection</Category>
<DataSources>
<DataSource ID="DS" TypeID="Microsoft.ISAServer.2006.Rule.AlertGenerate.DS">
<ComputerName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$</ComputerName>
<LogName>Application</LogName>
<EventsPattern>^(21192)$</EventsPattern>
<EventType>1</EventType>
<SourcePattern>Microsoft ISA Server Web Proxy</SourcePattern>
</DataSource>
</DataSources>
<WriteActions>
<WriteAction ID="WA" TypeID="Microsoft.ISAServer.2006.Rule.AlertGenerate.WA">
<AlertMessageId>$MPElement[Name="Microsoft.ISAServer.2006.The_ISA_Server_Web_Filter_was_unable_to_connect_to_the_MSDE_database.AlertMessage"]$</AlertMessageId>
<DomainName>$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/DomainDnsName$</DomainName>
<Priority>2</Priority>
<Severity>2</Severity>
</WriteAction>
</WriteActions>
</Rule>