Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Management Pack for SCOM User Guide

WMI errors

The following is a guide to troubleshooting WMI errors.

Error Solution

The RPC server is unavailable.

Exception from HRESULT: 0x800706BA

Spotlight on SQL Server is not able to establish a connection with the Windows server to be monitored.

Verify the following:

  • The address of the server is entered correctly. Verify correct host name or IP address. For more information, see Windows Server | Connection Details. Verify the host is available (not currently shut down).

  • The Remote Procedure Call (RPC) service is running on the Windows server to be monitored. Verity that "Remote Procedure Call (RPC)" is running and set to auto start after restart.

  • TCP Port 135 is open to internal traffic on the Spotlight Diagnostic Server and the Windows server to be monitored.

    WMI opens an undetermined port in addition to port 135. This can be troublesome in a firewalled environment. Specifying a port range for WMI is recommended for this type of environment.

  • The Windows server to be monitored is not blocked by the firewall.

    Either configure WMI to use a fixed ports range or enable remote administration exception.

    Follow these steps to enable remote administration exception.

    On the Windows server to be monitored:

    1) Open the Group Policy Object Editor (gpedit.msc), open Computer Configuration | Administrative Templates | Network | Network Connections | Windows Firewall

    2) Open either Domain Profile or Standard Profile, depending on which profile you want to configure.

    3) Enable the following exceptions: "Allow Remote Administration Exception" and "Allow File and Printer Sharing Exception".

    https://msdn.microsoft.com/en-us/library/windows/desktop/aa394603(v=vs.85).aspx

  • The "TCP/IP NetBIOS Helper" service is running. Verity that "TCP/IP NetBIOS Helper" is running and set to auto start after restart.

  • The "Windows Management Instrumentation" service is running on the Windows server to be monitored. Verity that "Windows Management Instrumentation" is running and set to auto start after restart.

Access is denied.

Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)

The Windows user specified is unknown to the Windows server or does not have administrator rights.

WMI connection time outs

The timeout value defaults to the value DCOM specifies (usually 60 seconds).

You can adjust this value via dcomcnfg.exe

WMI query failed: Invalid class.

[0x80041010]

The WMI class does not exist on the Windows server being monitored.

Solution: Recreate the WMI classes.

 

Windows Connections

Either of the following will recreate the WMI classes:

 

SQL Server Analysis Services Connections

Either of the following will recreate the WMI classes:

  • Open a command prompt window on the server hosting the SQL Server Analysis Services instance. Run the following command:

    wmiadap /f

  • Unregister and re-register the WMI classes. To do so:
  1. On the problematic machine with SQL Server Analysis Services installed, find out the SQL installation path. See below for the default installation path. Your installation path may be different.

    SQL Server Analysis Services 2014

    C:\Program Files\Microsoft SQL Server\MSAS12.MSSQLSERVER\OLAP\bin\Counters

    SQL Server Analysis Services 2012

    C:\Program Files\Microsoft SQL Server\MSAS11.MSSQLSERVER\OLAP\bin\Counters

    SQL Server Analysis Services 2008

    C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\bin\Counters

    SQL Server Analysis Services 2005

    C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\bin

    Note: You are looking for the folder that contains the following files:

    For unamed instances:

    MSSQLServerOLAPService

    perf-MSSQLServerOLAPServicemsmdctr.ini

    For named instances:

    MSOLAP$Your_SSAS_NamedInstanceName

    perf-Your_SSAS_NamedInstanceNamemsmdctr.ini

    If you need to check the named instance name, use services.msc.

  2. At the command prompt, change folder to the installation path.

    For example, cd C:\Program Files\Microsoft SQL Server\MSAS10.MSSQLSERVER\OLAP\bin\Counters

  3. Run the following commands to unload and load counters:

    unamed instances

    unlodctr MSSQLServerOLAPService

    lodctr perf-MSSQLServerOLAPServicemsmdctr.ini

    named instances

    unlodctr MSOLAP$Your_SSAS_NamedInstanceName

    lodctr perf-Your_SSAS_NamedInstanceNamemsmdctr.ini

    Tip: Replace Your_SSAS_NamedInstanceName with the SQL Server Analysis Services named instance name. If you need to check the named instance name, use services.msc.

  4. Run the following command to parse all the performance libraries on the Windows server and refresh the performance counter classes on the Windows server:

    wmiadap /f

  5. Use wbemtest.exe to verify the WMI Classes exist.

WMI query failed: Invalid query.

[0x80041017]

The columns returned by the WMI class are incomplete or unexpected.

Solution: On the Windows server to be monitored, update the WMI classes by running the following command at the command prompt.

wmiadap.exe /f

See https://msdn.microsoft.com/en-us/library/windows/desktop/aa394603(v=vs.85).aspx for more information.

0x80014064

User credentials cannot be used for local connections

This error occurs when wmic command is executed locally on the target machine and credentials specified

[0x800705af]

The paging file is too small for this operation to complete. For Windows Server 2008 R2 you may find the following link useful:

https://blogs.technet.microsoft.com/kevinholman/2010/06/09/wmi-leaks-memory-on-server-2008-r2-monitored-agents/

WMI query failed: Out of memory.

[0x80041006]

  1. At the command prompt run "wbemtest"
  2. Connect to the "root" namespace (not "root\default", just "root")
  3. Click Open Instance. Specify "__ProviderHostQuotaConfiguration=@"
  4. Select Local Only for easier readability. You will see the threshold values.
  5. Increase the MemoryPerHost value to something greater. For example, double it (256 MB)
  6. Save Property
  7. Save Object
  8. Click Exit.
  9. Restart WMI services.

Invalid verb

The wmic command has attempted to access a WMI class that does not exist.

Solution: Check the spelling of parameters on the wmic command.

Invalid Global Switch

The specified host, user or domain name contains special characters like '-' or '/'.

Solution: Modify the command by adding quotation marks.

wmic /node: 'MonHostFQDN' /user: 'DOMAIN\USER' path Win32_PerfRawData_PerfDisk_LogicalDisk get FreeMegabytes

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating