Skip to content
+44 (0) 330 99 88 700
Sign In Register
Ready to Talk?

SQL triggers not working. Error code 0x80037000

Table of Contents

Symptom #

Tasks triggered by the SQL trigger agent do not run and the BPA Platform 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 BPA Platform Configurator tool found from the Start menu in the Program group for BPA Platform.

  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.
Was this article useful?