Prepare To Install Reporting Services

The first step in setting up a report server is getting Reporting Services installed.  There are a few differences between the process for 2005 and 2008.  On the installation side, if you do not have the IIS setting configured before running the SQL install process you will not even be given the option to install reporting services in 2005.  You still have the option even without setting up IIS in 2008.  You will need a version of SQL Server that has reporting services, which includes the Standard, Enterprise, Workgroup and Evaluation editions.  The following changes are necessary to install reporting services 2005.

Before running the SQL Server Setup Wizard make the following changes:

In Windows Vista and Windows 7 the changes can be made by going to Control Panel > Programs and Features > Turn Windows Features on or off

From the box that opens check each of the following bold items:

  • IIS
    • Web Management
      • IIS6 Management Compatibility
        • IIS WMI Compatibility
        • IIS Metabase and IIS 6 configuration compatibility
  • World Wide Web Services
    • Application Development Features
      • .NET Extensibility
      • ASP .NET
      • ISAPI Extensions
      • ISAPI Filters
    • Common HTTP Features
      • Default Document
      • Directory Browsing
      • HTTP Errors
      • HTTP Redirection
      • Static Content
    • Security
      • Request Filtering
      • Windows Authentication 


In Windows Server open the Server Manager, then on the left side expand Roles > Web Server (IIS) then click Add Role Services in the right pane.

You will see a series of check boxes come up, of which the following bold items need to be checked:

  • Web Server
    • Common HTTP Features
      • Static Content
      • Default Document
      • Directory Browsing
      • HTTP Errors
      • HTTP Redirection
  • Application Development
    • ASP .NET
    • .NET Extensibiliity
    • ISAPI Extensions
    • ISAPI Filters
  • Health and Diagnostics
    • HTTP Logging
    • Request Monitor
  • Security
    • Windows Authentication
    • Request Filtering
    • Management Tools
      • IIS Management Console
      • IIS 6 Management Compatibility
        • IIS 6 Metabase Compatibility
        • IIS 6 WMI Compatibility
        • IIS 6 Scripting Tools
        • IIS 6 Management Console

From this point on any system, you are ready to run the SQL Server Setup Wizard.  Getting these setting is vital to having a working report server.  A missing setting could cause errors down the road, anything from permissions issues, to an error message telling you the report server is not there, when you know for sure it is…because you installed it.  During the install process you can chose the option to “Install the default configuration” or “Install but do not configure the server” which is completely up to you.  Remember to install any service packs and updates after you complete the initial installation.  In the next article in this series we will take a closer look at report server configuration including securing your report server with an SSL certificate.

Bradley Schacht

Bradley Schacht is a Data Platform Solution Architect on the state and local government team with Microsoft based in Jacksonville, FL. He has co-authored 3 SQL Server books including "SQL Server 2014 Professional Administration". As a former consultant and trainer, he uses his experience on many parts of the Microsoft BI and data platform to help customers deliver the best possible solutions. Bradley frequently presents at community events around the country. He is a contributor to sites such as SQLServerCentral.com and an active member of the Jacksonville SQL Server User Group (JSSUG).

You may also like...

Leave a Reply