Reporting Services 2005 on Windows 2008

  • Article

With new architectural changes in SQL Server 2008, it’s much easy to use and configure SSRS 2008 on Windows Server 2008 (No need of IIS). But problem comes when people try to install SQL 2005 Reporting Service on top of Windows Server 2008 and particularly x86 on x64 Platform. There are lots of such issues reported but none of them provide exact answer Sad smile I had to work on two similar engagements in the recent past so thought of sharing my experience with all of you.

Possible Scenarios:

Sceanrio1: You want to install SQL 2005 Express Reporting Services on Windows Server 2008 x64 box (typical scenario with Lync) but Reporting Service Checkbox in the installation Wizard is greyed out.

Scenario2: You have already installed SQL Reporting Service 2005 (Business SKUs) but it’s failing in configuration phase during IIS Pool Creation stage for ReportServer or ReportManager.

  • Make sure that you have selected below components while installing IIS/Web Server:
    • Common HTTP Features
    1. Static Content
    2. Default Documents
    3. Directory Browsing
    4. HTTP Error
    5. HTTP Redirection

  • Application Development

  1. Asp.Net
  2. .Net Extensibility
  3. ISAPI Extension
  4. ISAPI Filters
  • Health and Diagnostics
  1. HTTP Logging
  2. Request Monitor
  • Security
  1. Windows Authentication
  2. Client Certificate Mapping Authentication
  3. IIS Client Certificate Mapping Authentication
  4. Request Filtering
  • Performance
  1. Static Content Compression
  • Management Tools
  1. IIS Management Console
  2. IIS Management Script and Tools
  3. Management Service
  4. IIS 6 Management Compatibility
    • IIS 6 Scripting Tools
    • IIS 6 WMI Compatibility
    • IIS Metabase and IIS 6 configuration compatibility
  • IIS Manager Settings:
    • Go to IIS Manager
    • Select the Server and Application Pools
    • Select Set Action Pool Defaults from Action Pane
    • Select True from Drop Down option in Enable 32-bit Application under General
  • Restart IIS
  • Restart the SQL Setup (In case of SQL Express) or Restart the SSRS Configuration Manager (In case of SQL Business SKUs) and now you should be continue further without any further issues.

Some more details are documented in https://msdn.microsoft.com/en-us/library/bb839480(SQL.90).aspx