January 25, 2012 at 12:13 pm
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.
January 25, 2012 at 1:51 pm
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.
January 25, 2012 at 2:07 pm
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.
January 25, 2012 at 2:14 pm
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.
January 25, 2012 at 2:20 pm
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???
January 25, 2012 at 2:26 pm
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
January 25, 2012 at 2:34 pm
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.
January 25, 2012 at 2:40 pm
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.
January 25, 2012 at 3:07 pm
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...
January 31, 2012 at 12:00 pm
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?
January 31, 2012 at 12:06 pm
aberndt (1/31/2012)
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?
You could, provided that you don't want the existing installation or anything contained within it. I would recommend that you make a backup of the ReportServer database before you do.
To install/reinstall/repair SSRS, run the SQL Server setup utility and choose the advanced or custom option which will allow you to choose only the components you wish to install.
A restart will probably be required when the installation is complete.
January 31, 2012 at 12:08 pm
Thank you...I just wanted to be sure.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply