Surface Area Configuration for SSRS Using Policy Based Management


By:   |   Updated: 2010-05-25   |   Comments (2)   |   Related: > Reporting Services Configuration

Problem

I have installed a new instance of SQL Server 2008 Reporting Services and I am unable to find the Surface Area Configuration tool that I used to use in SQL Server 2005.  How do I manage the Reporting Services features in SQL Server 2008?

Solution

Surface Area Configuration was a great tool which was introduced by Microsoft in SQL Server 2005 to help SQL Server DBA's to quickly turn ON / OFF many of the features which are Turned Off by default in the product. However, Microsoft has removed Surface Area Configuration tool in SQL Server 2008. Now the question is how do you manage the Surface Area Configuration for Reporting Services? 

Database administrator can now use Policy Based Management to enable or disable feature for Reporting Services. Let us go through the steps to enable or disable Reporting Services feature using Policy Based Management.

Configure Surface Area Configuration for SQL Server 2008 Reporting Services

1. Connect to SQL Server 2008 Reporting Services Instance using SQL Server Management Studio.

2. In Object Explorer, right click the SQL Server 2008 Reporting Services Instance as shown in the below snippet and select Facets from the drop down list to open up Facets window.

Configure Surface Area Configuration for SQL Server 2008 Reporting Services

3. In the View Facets window you will be able to see the list of Facets which are available for SQL Server 2008 Reporting Services. You can select any of the Facet Properties and then select the value as True to enable the feature and choose the value as False to disable the feature as shown in the below snippet.

 see the list of Facets which are available for SQL Server 2008 Reporting Services

Once you have changed the values click OK to save the changes. It is advised to turn off the report server features that you do not want to use. This helps in reducing the potential attacks on the production report server instance.

Reporting Services 2008 Features which can be managed using Policy Based Management are:

  • ReportManagerEnabled: - You can use this to enable or disable Report Manager Configuration.
  • ScheduleEventsAndReportDeliveryEnabled: - Reporting Services uses schedules to trigger subscriptions, report cache expirations, and report snapshot executions. Enable scheduled events and report delivery if you schedule any of these operations. Otherwise it is better to turn off this feature.
  • WebServiceAndHTTPAccessEnabled: - The Report Server Web service can receive Simple Object Access Protocol (SOAP) requests and URL access requests. Enable Web Service and HTTP access only if your client applications use the web service or if you use Report Manager, Report Builder, or SQL Server Managements Studio with this Reporting Services installation.
Next Steps


Last Updated: 2010-05-25


get scripts

next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips





Comments For This Article




Sunday, January 06, 2013 - 5:41:57 PM - CK Back To Top (21280)

Mary,

Please try to run the program as an admin.

HTH

 


Thursday, July 12, 2012 - 2:10:42 PM - Mary Back To Top (18481)

This is what I trying to find in SQL Server 2008, but when I try to enable any of these options it just gives me a red X in the corner. Any thoughts?



download


Recommended Reading

SQL Server Reporting Services (SSRS) is not compatible with Internet Explorer 11

SQL Server 2016 Reporting Services Custom Branding Example

How To Enable Caching in SQL Server Reporting Services (SSRS)

SQL Server Reporting Services Configuration Tool

Making Adjustments to SQL Server Reporting Services Configuration Files





get free sql tips
agree to terms


Learn more about SQL Server tools