Monday, January 24, 2011

Impact on SSRS Reports 2005 during migration of Windows Server 2003 to Windows Server 2008

Microsoft has taken IIS out of the equation with SQL Server 2008 Reporting Services.

SQL Server 2005 Reporting Services, however, does depend upon IIS to manage and share reports. This works very well with Windows Server 2003 and IIS 6.x. This version of Reporting Services is not fully compatible with IIS 7.5, which is provided with the operating system (Windows Server 2008). IIS 6 components of IIS 7.5 are required for Reporting Services.

The impact can be avoided by installing IIS 7.5 role with some specific options selected as mentioned below:

1. The most common services and features are automatically included when we install the IIS 7.5 role on Windows Server 2008 and Windows Server 2008 R2. It turns out there are a few more features that Reporting Services 2005 requires. The first one is: IIS 6.0 Management Compatibility. While selecting this feature, please make sure that all of the sub-features are selected.

2. Moving up to the Common HTTP Features section, you will notice that not all of the sub-features are selected. The HTTP Redirection and WebDAV Publishing are not selected for installation. HTTP Redirection is required for SSRS Reports 2005, so make sure to install it. The WebDAV Publishing feature is not required by Reporting Services 2005.

3. In the Application Development section, please select the ASP.NET option.

4. The Windows Authentication option is a required security feature. Please check Windows Authentication under the Security section.

5. If a dialog appears to tell you that other features are required as you make these selections, please click OK to install those features.

6. After installing the new role features is complete, go to the Services control panel and confirm that the World Wide Web Publishing Service is set to start automatically, and is running.

7. Now you can run the SQL Server 2005 setup and install Reporting Services. When installing Reporting Services, go ahead and select the configuration option for standalone or SharePoint integration. Setup will walk you through the configuration process.

Note that this is how to install SQL Server 2005 Reporting Services 64-bit version. If you need to install the 32-bit version on Windows Server 2008, please take a look at the Microsoft Knowledge Base article at http://support.microsoft.com/kb/934162/ for details.

No comments:

Post a Comment