Microsoft KB Archive/295864

= SQL Trace Log Provider Not Working as Expected =

Article ID: 295864

Article Last Modified on 10/27/2006

-

APPLIES TO


 * Microsoft Operations Manager 2000 Service Pack 1

-



This article was previously published under Q295864



SYMPTOMS
After you create a Microsoft SQL Server-based trace file provider and set up an Event Collection Rule to collect data from the .trc SQL trace file format, nothing may be collected and reported in Microsoft Operations Manager (MOM).



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
You may notice that no events are collected and no alerts are generated when you define an Alert On or a Respond To Event processing rule.

Steps to Reproduce the Behavior
 After you create the provider and an event collection rule in MOM, initiate a SQL Trace on the target SQL server and enable the &quot;Write to File&quot; option. Under the following registry location, a registry entry indicates that MOM has recognized the trace file provider:

HKEY_LOCAL_MACHINE\SOFTWARE\Mission Critical Software\OnePoint\Configurations\ \Operations\Agent\Event Providers\Application Log

However, the events from this file are not collected or reported.

Keywords: kbbug kbenv kbnofix KB295864

-

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

© Microsoft Corporation. All rights reserved.