Thursday, January 20, 2011

Installing Reporting Services on SQL 2005 on Windows 2008

Quick Description:  On Windows 2008 R2, even after installing the web server role and registering the .net framework with IIS, reporting services is greyed out as an option when attempting to install it to an existing instance.

Problem:
A while back I wrote an article on installing Reporting Services on an existing SQL 2005 instance.  These steps work for Windows 2003.  However, if you should for some reason want to install SQL 2005 SP3 on Windows 2008 R2 (it's not the most common configuration, but maybe your licensing only allows up to 2005), these steps won't get you to the point where SQL 2005 will allow you to install reporting services.  In my case, after following the steps in the original article (substituting adding the role in Server Manager, instead of adding IIS in add/remove windows components), and registering .net with IIS, Reporting Services was still greyed out as an option in setup.

Solution:
I fumbled my way through this one before finding this article that Microsoft published on the subject.   It's messy, but it works.  It also probably demonstrates that SQL 2005 isn't really meant to be installed on Windows 2008 R2.

1 comment:

  1. At present you're sure the correct way very important it will be to help you be dressed in a very good sit back and watch. prada replica As a result just how do you continue ordering the right one for your own benefit? replica prada You can get plenty of versions and even so many different includes enjoy chronograph, accelerometer, twice precious time -- hublot replica uk oh-so-overwhelming! Though every one of might arrange by themself over knowing the correct way ones own intake ıs going to be. replica cartier When you're an important sportsman, it will be herbal that you require running watches seem to be includes enjoy chronograph, lap-timing include, some storage devices, stopwatch etc .. hublot replica An exercise supporter have to this type of includes at the same time.

    ReplyDelete