Adsense

Tuesday, September 09, 2008

Reporting Services is grayed out after adding reporting services to an existing MS SQL install

You can add Reporting Services to an existing install of MS SQL in Windows Vista (not sure how different the step would be in XP) by following these steps.

  1. Open Programs and Features (press the windows key, type in Programs and Features and press enter)
  2. Right-Clicking on Microsoft SQL Server 2005  and click Change.
  3. Under SQL Server 2005 instances:  select the instance you want to add reporting services to and click Next
  4. Click on To install a new component, click here
  5. Browse to the Setup.exe file on your installation disk and click OK
  6. Click through the wizard until you get to the Components to Install screen
  7. Select Reporting Services  and finish the wizard.

It's that simple... Unless Reporting Services  happens to be Grayed Out. If this is the case for you, you are probably missing requirements that Reporting Services needs. During the above process, you came to a screen called System Configuration Check and you probably got a yellow exclamation point on IIS Feature Requirements. Basically, you need to add some features to your IIS installation before you can install reporting services.

 

To enable these IIS features, follow the steps below.

  1. Open Programs and Features (press the windows key, type in Programs and Features and press enter)
  2. Click on Turn Windows features on or off to bring up the Windows Features window
  3. Expand the Internet Information Services option and place check marks next to all the features you want to install
  4. Click OK to install the features.

Here is a list of features that are required before you can add Reporting Services to your existing MS SQL Server installation. (Reference here.)

Component Folder
Static Content Common HTTP Features
Default Document Common HTTP Features
HTTP Redirection Common HTTP Features
ASP.Net Application Development
ISAPI Extension Application Development
ISAPI Filters Application Development
Windows Authentication Security
IIS Metabase Management Tools
IIS 6 WMI Management Tools

 

After adding these features, try to perform the steps above for adding Reporting Services to an existing MS SQL Installation and Reporting Services should not be grayed out. Hope this helps.