stored procedure on a named cluster instance of Microsoft SQL Server 2008, you receive the following error message:
SQLServerAgent Error: WMI error: 0x80041013.
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.
This problem does not occur if the cluster's SQL network name has exactly 15 characters.
The SQL network name is also known as the virtual SQL Server name.
Before you try to change the virtual SQL Server name, make sure that you have read the following items:
- SQL Server does not support renaming servers that are involved in replication unless you use log shipping together with replication. The secondary server in log shipping can be renamed if the primary server is permanently lost. For more information, visit the following Microsoft Developer Network (MSDN) Web site:
- When you rename a virtual server that is configured to use database mirroring, you must turn off database mirroring before the renaming operation, and then you must re-establish database mirroring by using the new virtual server name. Metadata for database mirroring is not updated automatically to reflect the new virtual server name.
Article ID: 960573 - Last Review: May 8, 2009 - Revision: 1