Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

WMI Provider Error Invalid Namespace Expand / Collapse
Author
Message
Posted Wednesday, January 25, 2012 12:13 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
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.
Post #1241690
Posted Wednesday, January 25, 2012 1:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:06 PM
Points: 317, Visits: 3,614
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.




Post #1241769
Posted Wednesday, January 25, 2012 2:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
Martin - Thank you for the information. I have confirmed that SSRS is installed both on the server and on my workstation. I have inherited this server...it appears that someone may have attempted to do this in a past life and there are remnants of a failed configuration. Is there anyway to add a new report database and get rid of any reference to an old one??? There are no reports that have ever been created in SSRS that are being used.
Post #1241781
Posted Wednesday, January 25, 2012 2:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:06 PM
Points: 317, Visits: 3,614
aberndt (1/25/2012)
Martin - Thank you for the information. I have confirmed that SSRS is installed both on the server and on my workstation. I have inherited this server...it appears that someone may have attempted to do this in a past life and there are remnants of a failed configuration. Is there anyway to add a new report database and get rid of any reference to an old one??? There are no reports that have ever been created in SSRS that are being used.


You should be able to just reinstall it on the server by running the setup utility. For clarity, SSRS does not have to be installed on both your workstation and the server.



Post #1241786
Posted Wednesday, January 25, 2012 2:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
I see 2 databases in SSMS called XXReports and XXReportsTempDB, should I delete these before I reinstall??? I am going to be the only one creating reports in SSRS and then I will make them available to other users. Should SSRS be installed on the server or my workstation? If I install it on my workstation, what needs to be done to the server to allow it to function as the report server? I really apologize for all of the questions, you are being very helpful. Is there somewhere that has a step-by-step guide to getting started???
Post #1241790
Posted Wednesday, January 25, 2012 2:26 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:06 PM
Points: 317, Visits: 3,614
aberndt (1/25/2012)
I see 2 databases in SSMS called XXReports and XXReportsTempDB, should I delete these before I reinstall??? I am going to be the only one creating reports in SSRS and then I will make them available to other users. Should SSRS be installed on the server or my workstation? If I install it on my workstation, what needs to be done to the server to allow it to function as the report server? I really apologize for all of the questions, you are being very helpful. Is there somewhere that has a step-by-step guide to getting started???


It is better to install SSRS on the server, otherwise it will not be accessible if your workstation is off etc.

If you are going to reinstall SSRS, you can remove those 2 databases as it will have no effect. The current names of those databases should not have the "XX" in the name. Maybe if you remove that it would fix the issue...but if there is any uncertainty on your part it may be better to create a clean installation.

EDIT: Please make sure though that those databases are not used for anything else, before you delete it. Or at least create backups.

For more information on SSRS, see the following: http://msdn.microsoft.com/en-us/library/ms159106.aspx



Post #1241793
Posted Wednesday, January 25, 2012 2:34 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
Again, sorry to sound stupid (the class was only 2 days, over a year ago), but how will I write the reports if SSRS is not installed on my workstation? The XX's in the DB name were actual letters unique to our company, not real X's. Anyway, I removed the DB's and still have the same errors. I will begin reading the information you provided. Thank you again.
Post #1241797
Posted Wednesday, January 25, 2012 2:40 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 6:06 PM
Points: 317, Visits: 3,614
aberndt (1/25/2012)
Again, sorry to sound stupid (the class was only 2 days, over a year ago), but how will I write the reports if SSRS is not installed on my workstation? The XX's in the DB name were actual letters unique to our company, not real X's. Anyway, I removed the DB's and still have the same errors. I will begin reading the information you provided. Thank you again.


Reports are usually hosted on the server (on which SSRS is installed). You will typically use Visual Studio or BIDS (Business Intelligence Development Studio) to develop your reports, including the data sources which the report will use to connect to a database for the relevant data etc.

After your development is complete you will typically deploy the reports to the server, at which time it will be accessible to everyone who has the relevant permissions to view/execute these reports.

The content databases are used to store the source (XML definition) of the reports once they are deployed, so everything is hosted on the Report Server.

My suggestion would be that you go through all the documentation and workshops on MSDN (Books Online) to refresh your memory. It's easy to forget if the class was that long ago and you've never used the technology since.



Post #1241803
Posted Wednesday, January 25, 2012 3:07 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
Sorry, that was a stupid question...I only have the Business Intelligence Development Studio installed on my workstation, some stuff is coming back to me. Yes, I will continue reading...
Post #1241813
Posted Tuesday, January 31, 2012 12:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, July 3, 2014 7:12 AM
Points: 60, Visits: 115
Martin - Can I just reinstall SSRS and not override anything else? How would I do that? I did not do the original install and don't want to alter anything that shouldn't be. Do you know if a restart will be required?
Post #1244663
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse