Issues installing 32 bit SSRS on 64 Bit Windows 2008 Server

Goal 

You are moving an instance of SQL from a 2003 32 Bit server to 2008 server 64 Bit Server.  

     

Environment

2008 Server 64 bit SP 2, SQL Server 2005 32 Bit SP 2.  IIS 7.0.

Issue

           I had three separate issues. All were in the report on the System Configuration Check Page the SQL Install.   

1)      First even though IIS was Installed it was telling me that IIS was not installed or configured.

2)      Error saying that ASP.NET was Required

3)      Version Error saying I should run System SKUUPGRADE = 1

Resolution

The First Error was:

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

I had originally installed IIS from Windows 2008 using defaults. Don’t Do that. Uninstall and Reinstall IIS using the right options. See this article: http://support.microsoft.com/kb/920201
You have to check the following OVER AND ABOVE the defaults:

Component	Folder
Static Content	Common HTTP Features
Default Document	Common HTTP Features
HTTP Redirection	Common HTTP Features
Directory Browsing	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

Next Error I was getting this:

64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Service 2005 (32.bit).

64 Bit ASP.Net was already installed. So was 32 Bit ASP.Net. Both were showing up in IIS. But I would click on next and the option to install SSRS would be greyed out. So I knew I had to fix the problem. To do this You just need to go into your main web site (Port 80) and click on application pools. Click on the Set Application Pool Defaults in the Actions Pane. Then in the General Section Set Enable32bitApponWin64 to True.
Fix is buried in here: http://support.microsoft.com/kb/934162

The final error you can ignore. I could have run the command line for Setup SKUUPGRADE = 1. But I didn’t have to. It let me proceed without error.

Another thing to mention: Make sure when you are setting up SSRS that you select the Classic not the Default App Pool. You will get a HTTP 523 error.

Last thing to mention: I restored the reportserver and reportservertempdb databases and connected them in the setup screen to my instance. Of course I had to delete encrypted content (an Option in SSRS Setup Screen under where you create keys or restore). This gets rid of data connection info in shared data sources and any schedules setup. Not a big deal to recreate either one.

Conclusion

                Moving SQL SSRS to a 64 bit server has some pitfalls but can easily be done. You should just do 64 bit (will get rid of most of these errors) but in my case we could not.