Export (0) Print
Expand All
0 out of 1 rated this helpful - Rate this topic

Troubleshooting WMI Provider Errors

SQL Server 2005

New: 17 November 2008

While using the Reporting Services Configuration Manager or SQL Server Management Studio, you may encounter Windows Management Instrumentation (WMI) provider-related errors. Before you continue with the troubleshooting steps, you should rule out other possible error sources, such as SQL Server and the report server not functioning correctly. To do so, restart both your SQL Server instance and your SQL Server Reporting Services instance, and then check if the problem persists.

To troubleshoot using the WMI Tester
  1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
  2. Open a command prompt and type wbemtest, and then click OK.
    This opens the Windows Management Instrumentation Tester dialog box.
  3. Click Connect.
  4. In the Namespace field, type the following string, and then click Connect.
    root\microsoft\sqlserver\reportserver \v9
    The namespace you specify should appear in the WMI Tester dialog box. If you see an error message instead, the WMI namespace for Reporting Services is not registered correctly. To resolve this issue, follow the procedures later in this article for registering the WMI namespace for Reporting Services.
  5. Click Enum Classes, and click OK in the Superclass Info window.
  6. In Top-level classes list of the Query Result window, double-click the MSReportServer_Instance class.
  7. Click the Instances button. You should see a Query Result window that shows all the instances of Report Server on your computer. If not, the Reporting Services WMI provider is not communicating with Reporting Services Configuration Manager or SQL Server Management Studio. To resolve this issue, follow the procedures later in this article for registering the Reporting Services WMI provider.
  8. If you successfully resolved the issues in the WMI Tester dialog box, restart Reporting Services Configuration Manager or SQL Server Management Studio to determine whether that the error is resolved.
To register the WMI namespace for Reporting Service
  1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
  2. Open a command prompt.
  3. Add the class instance of the Reporting Services WMI provider to the WMI repository. In the command prompt, run the following command:
    mofcomp "%ProgramFiles%\Microsoft SQL Server\90\Shared\reportingservices.mof"
  4. Run the WMI Tester again to see whether you can now connect to the namespace for the Reporting Services WMI provider and continue with the debugging process.
To register the Reporting Services WMI provider
  1. Close all instances of Reporting Services Configuration Manager or SQL Server Management Studio.
  2. Open a command prompt.
  3. Register the Reporting Services WMI provider. In the command prompt, run the following command:
    regsvr32 "C:\Program Files\Microsoft SQL Server\90\Shared\reportingserviceswmi.dll
  4. Run the WMI Tester again to see whether you can now connect to the namespace for the Reporting Services WMI provider and continue with the debugging process.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.