SQL triggers not working. Error code 0x80037000

Symptom

Tasks triggered by the SQL trigger agent do not run and the TaskCentre event log records the following error code:

0x80037000

Cause

This error occurs because by default versions of SQL Server starting with SQL Server 2005 provide a restricted set of features.

Resolution

The resolution is to enable OLE Automation by using the TaskCentre Configurator tool found from the Start menu in the Program group for TaskCentre.

  1. Within the Configurator navigate to: Event Agents >Microsoft SQL Server Trigger Agent > Prerequisites
  2. For the SQL Server OLE Automation prerequisite click the Modify button and tick Enable Ole Automation.