none
WMI error 0x8004100e on sql server 2008 R2

    Question

  • on a sql server 2008 r2 server i am seeing following error in sql agent log

    'unable to register the alert xxx with wmi porivder. The alert is ignored. WMI error 0x8004100e.

      I am running query 'select * from DATABASE_MIRRORING_STATE_CHANGE' . Also the sql agent account is part of sysadmin. I have setup this alert to monitor mirroring state change alerts.

    any help will really appriciate.

    Thanks

    Anoop

    Monday, February 13, 2012 1:08 PM

Answers

  • it works if you specify the database in the query-

    SELECT * FROM DATABASE_MIRRORING_STATE_CHANGE WHERE Database = 'MyDatabase'


    http://uk.linkedin.com/in/ramjaddu

    Tuesday, February 14, 2012 10:34 AM