SQL Server 2005 Reporting Services install option is greyed out

Dev

SQL Server 2005 Reporting Services install option is greyed out

by Brian Bickell
//

A client recently requested that we add Reporting Services to his existing install of SQL Server 2005. I didn’t think much of this task until I ran the setup and found that the checkbox for Reporting Services was greyed out. After some amount of digging I found the answer.

IIS is a prerequisite for installing SSRS 2005. SSRS 2008 has the same prerequisite.

To install IIS 6.0 in Windows Server 2003:

  1. Go to Add or Remove Programs, under Control Panel
  2. Select Add/Remove Windows Components
  3. Check the Application Server checkbox, and click Details…
  4. Check the Internet Information Services (IIS) checkbox and click OK
  5. Click Next. The install now will determine what files it needs
  6. Point the wizard at a location containing the operating system media. Be sure you have the correct version and correct architecture (x86 = i368, x64 = amd64).

If you’re adding Reporting Services to an existing SQL Server install you’ll want to be sure to update it to the same version as the other components. Installing any necessary service packs, or hotfixes will allow you to upgrade SSRS without affecting the database engine.

Installing on Windows Server 2008 can be a bit more difficult, because you’ll have to configure the IIS 6.0 Compatibility Mode options. For more information on installing SSRS on Windows Server 2008 see this link: http://msdn.microsoft.com/en-us/library/bb839480%28SQL.90%29.aspx?ppud=4

More About the Author

Brian Bickell

Global Data Practice Director
Introducing the Snowflake Data Cloud: How We Got Here Five years ago, in the distant past that still included large, boozy, in-person technology conferences, I met two guys from an upstart ...
InterWorks’ Influential Role at the KeyBanc Capital Markets Emerging Technology Summit Two weeks ago, KeyBanc Capital Markets and the Mosaic network held their 15th Annual Emerging Technology Summit in San Francisco, ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072