4. January 2008 14:50 by
in Reporting Services, SQL Server
I've had to go through installing reporting services on IIS7 a couple of times now (on Vista machines for development environments - but the same rules apply for IIS7 on Windows Server 2008). When running the install for SQL Server 2005 the option to install Reporting Services was not available. I double checked that I had IIS and ASP.NET extensions installed. They both were, but I still couldn't get the SQL installer to enable the Reporting Services option.
It turns out that Reporting Services on SQL Server 2005 is dependent on the IIS6 or earlier structure. Thankfully, IIS7 supports IIS6 backwards compatibility. Here are the steps to install the additional windows components prior to running the SQL Server 2005 Reporting Services setup.
1. Open "Programs and Features" from your Control Panel.
2. Click on "Turn Windows features on or off"
3. Install the following features
-Internet Information Services
- -Web Management Tools
- - -IIS 6 Management Compatibility
- - - -IIS 6 WMI Compatibility
- - - -IIS Metabase and IIS 6 configuration compatibility
- -World WIde Web Services
- - -Application Development Features
- - - -ASP.NET
- - - -ISAPI Extensions
- - - -ISAPI Filters
- - -Common Http Features
- - - -Default Document
- - - -Directory Browsing
- - - -HTTP Redirection
- - - -Static Content
- - -Security
- - - -Windows Authentication
Once these are installed you should be able to install SQL Server 2005 with Reporting Services (and all other add ons as well). Make sure you install SQL Server SP2 once the installation is complete.