Installing Reporting Services 2005 on Windows Server 2008 R2

  • Article

I've recently moved to the SQL Developer Team and I'm currently building a one stop SQL machine with SQL 2005, 2008 and 2008 R2 (all 64bit versions) side by side and I've come across an issue installing SSRS 2005.  There are plenty of blog posts out there stating that IIS6 compatability must be installed and that .NET 32bit on 64bit must be set to false however following these I still was not able to install Reporting Services 2005.  It wasn't until I found the following article which has an adsutil script to run that installation was possible.

I'd reccomend everyone seeing this issue run the script rather than checking the 32 on 64 setting in the GUI, for some reason the script succeeded where the GUI failed.

https://msdn.microsoft.com/en-us/library/bb677367(SQL.90).aspx

Hope this helps,
Jason