Home Forums Reporting Services Reporting Services WMI Provider Error Invalid Namespace RE: WMI Provider Error Invalid Namespace

  • January 25, 2012 at 1:51 pm

    #1438435

    aberndt (1/25/2012)

    I am trying to set up SSRS in my organization for the first time. I took one class on this over a year ago and am trying to make sense of my notes but not having much luck. I have a few questions and several errors... Please forgive me if some of these sound stupid, I am not all that familiar with SQL... I'd like to use my SQL Server as the report server, can I? If so, how do I connect to it? I keep getting 'Cannot connect to SERVERNAME', 'Report Server WMI Provider Error: Invalid namespace (Microsoft.SqlServer.Management.UI.RSClient) Invalid namespace (System.Management)' when I try to use SSMS. If I try to connect to SERVERNAME from my workstation using Reporting Services Configuration Namager, I get 'An unknown error has occurred in the WMI Proder. Error Code 800705AF'. I'm not sure where to start troubleshooting. Thank you in advance for your help.

    Yes, you can use your SQL Server as the Report Server as well...although it isn't recommended for production environments. In a production environment, it is recommended best practice to use your database server for the SSRS content databases...but a separate web server for the SSRS portal (front-end).

    From the error you are getting, it almost seems like Reporting Services might not be installed on your machine at all. SSRS is a separate installation, so you may have to run the setup utility again.

    SSRS should run under its own service, so that is one way to see establish whether it is installed or not. You can also use the Reporting Services Configuration Tool. If you don't see this tool on your machine, the chances are that SSRS is not installed.

    Also, the default url for the Report Server front-end should be http://<your-machine-name>/Reports

    unless you have a named instance (check BOL for the default in that case). See if you can navigate to that url on your SSRS machine, and if it cannot be found the chances are that SSRS is not installed.

    Hope this helps. Please use BOL (Books Online) as a refence for other best practices and guidelines when setting up a Report Server etc.