Core Cannot Obtain the SQL Metadata on a SQL Cluster (4036075)

After the successful installation of a SQL agent, the Core cannot retrieve the SQL metadata. The following error appears in the AppRecovery logs:

ERROR 2013-08-21T16:39:36 [75] – Replay.Common.Implementation.WmiApi.Wmi (RequestUri=https:// (name of agent):8006/apprecovery/api/agent/metadata/fullClusterMetadata ClientAddress=(agent ip address):58008 Service=Replay.Agent.Management.Metadata.AgentMetadataManagement Method=GetCurrentCluster)

Unknown WMI error: Invalid class

System.Management.ManagementException: Invalid class

at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)

at System.Management.ManagementObjectCollection.ManagementObjectEnumerator.MoveNext()

at System.Linq.Enumerable.<CastIterator>d__b1`1.MoveNext()

at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)

at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)

at Replay.Common.Implementation.WmiApi.Wmi.<>c__DisplayClass2a.<ExecuteQuery>b__29()

AppAssure uses a special class (serviceNetworkProtocol) to query SQL metadata on the agent. This error results when the class is missing from the WMI repository.

To resolve this error, complete the following steps.

1. Run the Managed Object Format (MOF) compiler. The MOF parses a file containing MOF statements and adds the missing classes and class instances defined in the file to the WMI repository.
2. Run the following command: mofcomp “C:\Program Files (x86)\Microsoft SQL Server\###\Shared\sqlmgmproviderxpsp2up.mof”
1. NOTE: ### can be 90, 100, or 110 depending on the version of SQL Server installed. Select the highest available number.
2. NOTE: For this command to succeed, the sqlmgmproviderxpsp2up.mof file must be present in the %programfiles(x86)%\Microsoft\Microsoft SQL Server\###\Shared folder.

For more information, please refer to the following Microsoft Technet articles:

• http://support.microsoft.com/kb/956013/en-us
• http://technet.microsoft.com/en-us/library/hh872947.aspx
• http://msdn.microsoft.com/en-us/library/windows/desktop/aa392389%28v=vs.85%29.aspx