March 4, 2009 at 2:55 am
Folks,
I had to install SQL 2008 with Reporting Services on a machine that had SQL 2005 already installed.
Now the client wants RS 2005 to also be installed on the machine.
Has anyone done this in this order and can you give any advice caveats?
Thanks in advance guys
Mick
March 4, 2009 at 10:33 am
I run both in my development box but you need to know you must have IIS 6 or 7 installed and configured before you can install SSRS 2005 and IIS 7 in Win2008 must be configured to run in IIS 6 compatibility mode.
And in Win2003 you need to click on details during IIS 6 installation so you can enable all the features needed to run Asp.net and go to your C drive in both cases and run aspnet_regiis. And in Win2008 you have to make IIS 6 use port 8080 because SSRS in Win2008 require port 80 open which is the default port for IIS. I am running XP so I think you need to know.
Kind regards,
Gift Peddie
March 4, 2009 at 12:27 pm
Thanks for this. Not much info around on what I am trying to do. It is a windows server 2008 box with IIS 7 that I am deploying this on. If you can give me any additional info I would really appreciate it.
March 4, 2009 at 2:15 pm
The first link covers SSRS 2008 configurations in Win2008 and the second link covers IIS 7 configuration in IIS 6 compatibility mode. You need to install and configure IIS before you run the installer or SQL Server 2005 installer will disable SSRS. Post again if you still need help.
http://technet.microsoft.com/en-us/library/bb630430.aspx
Kind regards,
Gift Peddie
March 4, 2009 at 11:33 pm
thanks gp
March 5, 2009 at 5:52 am
So, I have SQL 2008 with reporting services installed, along with SQL 2005.
When I am attempting now to add Reporting Services 2005 I am getting.
The following components that you are attempting to install are already installed on the machine.
and then greyed out
Reporting Services 10.0.1600.22
Can anyone confirm if it is possible to install RS 2005 on a machine with an existing RS 2008 installation?
March 5, 2009 at 6:03 am
That is reporting services 2008 you need to rerun the SQL Server 2005 installer and choose repair and make sure you have installed and configured IIS7 in IIS6 compatibility mode.
Kind regards,
Gift Peddie
March 5, 2009 at 6:14 am
Hmm. I am not getting a repair option for SQL 2005
March 5, 2009 at 6:35 am
If you don't get repair there must be install option run it so you can get to choose components and choose SSRS.
Kind regards,
Gift Peddie
March 5, 2009 at 7:04 am
I'm not sure you can have two different versions of Reporting Services on a single machine. I'm recalling reading somewhere that RS can only have one instance - just like with the client tools. Shut me up if I'm all wet, but I think what you're looking for can't actually happen.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 5, 2009 at 7:17 am
I am not aware of such restriction and here is a thread with known issues resolved and both versions of SSRS running. If it is not allowed Microsoft would have said so but instead resolved the problem for the user.
Kind regards,
Gift Peddie
March 5, 2009 at 7:47 am
Folks,
Apparently its possible....
http://msdn.microsoft.com/en-us/library/ms143736.aspx#installmultiinstance
....but it looks like I need to install RS 2005 first and then RS 2008.
Trying this now
March 5, 2009 at 8:36 am
So, I removed RS 2008 installed RS 2005, tested some report projects.
then I installed RS 2008
Ran into a "invalid namespace" error when trying to select the RS2008 service in the Reporting Services Configuration Tool.
Fix for that is here.
Seems that sometimes the %Program Files\Microsoft SQL Server\MSR10.%instancename%\Reporting Services\reportserver\bin\reportingservices.mof gets a bit munged during setup.
Your instance name gets RS suffixed to it. so "MYINSTANCENAME" becomes "RS_MYINSTANCENAME" and the instance name does not get picked up by the config tool . You need to create a copy of the reportingservices.mof file, do a find and replace to set all instances of "RS_MYINSTANCENAME" back to "MYINSTANCENAME".
Once this is done open a command prompt from the above folder and run
MOFCOMP REPORTINSERVICE.MOF against your new .mof file.
Now you can configure the service.
Thanks For your help guys
March 5, 2009 at 9:26 am
Super!!! Sounds like it's challenging in the typical MS way, but cool beans!
Steve
(aka smunson)
:smooooth::smooooth::smooooth:
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply