Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Administering SSRS Services Using SSMS


By:   |   Last Updated: 2010-08-02   |   Comments (3)   |   Related Tips: > Reporting Services Administration

Problem

In SQL Server Reporting Services 2008 R2, the architecture has changed from the SSRS 2005 version. The biggest change in my view is that all the major SSRS services are wrapped up in a single Windows service. This Windows service contains different services like Report Manager, Report Server and Scheduling. Although all of these services are wrapped in a single service, we may need to administer access to these services independently depending on the requirements. In this this we would take a look at how to address this requirement.

Solution

SSRS 2008 has been shipped with a lot of enhancements to Reporting Services and better administration is one of them. SSMS has been enhanced with some useful administrative options for SSRS. In this tip we cover how to turn Reporting Services features on or off using SSMS.

To connect to a Reporting Services instance, follow the below steps.

1) Logon to Report Server using SSMS as shown below.

In SQL Server Reporting Services 2008 R2, the architecture has changed from the SSRS 2005 version

2) After logging into the server, in the Object Explorer pane you should be able to see the Report Server listed. Right-click on the report server and select "Facets" as shown in the below screenshot.

SSMS has been enhanced with some useful administrative options for SSRS

3) After you click on the Facets menu, you should see the dialog shown below. This screen has three properties that allows you to toggle various services of SSRS such as; Report Manager, the SSRS web service and Scheduling options.

  • ReportManagerEnabled - Enables / Disables Report Manager
  • ScheduleEventsAndReportDeliveryEnabled - Enables / Disables Scheduled Events and Delivery
  • WebServiceAndHTTPAccessEnabled - Enables / Disables the Report Server Web Service

This screen has three properties that allows you to toggle various services of SSRS such as; Report Manager, the SSRS web service and Scheduling options

4) Also if you select an option by clicking on it, like ScheduleEventsAndReportDeliveryEnabled shown below, you can see the description to get a better idea of the effect of toggling this facet.

administering using SSMS is an easier and safer way of doing this

If there is a need to not have access to all these SSRS services you can use this approach to turn items on and off. Also in an emergency or maintenance window, you might need to bring down certain services which can be done very easily using this approach.

Keep in mind that the same items can be modified in the RSReportServer.config file, but administering using SSMS is an easier and safer way of doing this.

Next Steps
  • Check your current settings for your Reporting Services installation.
  • Toggle the value of any of the services like Report Manager for example.
  • Check how quick the change is once it is made using these options in SSMS.
  • For additional options refer to this Microsoft article


Last Updated: 2010-08-02


next webcast button


next tip button



About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Friday, April 22, 2011 - 6:43:47 PM - Frank Q Back To Top

I found the Connection to Report Service in SSMS wierd. First the Reports databases are not located in reporting Services Server but in the Instance of the Database Engine. I even wonder why we need to have a reportservices Server at all shows in SSMS. I wonder why all the setup is not include in Reporting Services Configuration Manager. It seems as Microsoft was in a rush puting together ther GUI


Monday, August 02, 2010 - 10:00:41 AM - admin Back To Top
this has been fixed.

Monday, August 02, 2010 - 8:52:47 AM - dj Back To Top
Pictures are not displaying.  :(

Learn more about SQL Server tools