SQL Server Development Bookmark and Share   
 index > SQL Server Database Engine > Error when creating WMI alerts on SQL Server 2005 and SQL Server 2008
 

Error when creating WMI alerts on SQL Server 2005 and SQL Server 2008

Hi All

I am trying to setup alerts on SQL Server 2005 and new install of SQL Server 2008. When trying to create the alert I am getting: -

Msg 22022, Level 16, State 1, Line 0

SQLServerAgent Error: WMI error: 0x8004100e.

Msg 14511, Level 16, State 1, Procedure sp_verify_alert, Line 300

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.

Any assistance would be much appreciated, I have seen the microsoft post about the server name length and all mine are under 10 characters long.

Thanks

Mike

Mikelang  Tuesday, August 12, 2008 9:57 PM

Mike,

Have a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3666804

I provided how I solved this problem there.

Jonathan Kehayias  Tuesday, August 19, 2008 5:46 PM

Mike,

Have a look at this post:

http://forums.microsoft.com/MSDN/ShowPost.aspx?siteid=1&PostID=3666804

I provided how I solved this problem there.

Jonathan Kehayias  Tuesday, August 19, 2008 5:46 PM

You can use google to search for other answers

Custom Search

More Threads

• Need help interpreting results of SET STATISTICS TIME ON
• Refreshing an indexed view
• Examples of Bad Databases
• Locking issues with SQL 2005 database
• Change data capture bug in sql 2008
• How does SS08 INDEX compression work
• SQL Server Active Active Cluster Question
• job schedules
• How to change SQL server 2008 collate after installation
• Cannot obtain the required interface ("IID_IDBSchemaRowset")