WMI Alerts - could not be executed in the @wmi_namespace provided

• MG-148046

  SSCrazy Eights

  Points: 9946

  More actions

  July 1, 2015 at 11:35 am

  #299712

  I'm trying to create alerts for mirroring and I get this error:

  The @wmi_query could not be executed in the @wmi_namespace provided. Verify that an event class selected in the query exists in the namespace and that the query has the correct syntax. (Microsoft SQL Server, Error: 22022)

  The account that runs the SQL Server Agent is a member of the sysadmin and is in the local admin group. Service Broker is enabled in msdb. As far as I can tell that is all I need. Totally by accident I discovered that if the NT Authority\System account is a member of sysadmin, the alert will be created and work. I tried removing the account from sysadmin and the alert does not fire.

  We can't have this account in sysadmin in our environment.

  Any insight would be much appreciated

  MG

  "There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
  Tony Hoare

  "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.