Installing multiple instances of reporting services on the same server

Question

Installing multiple instances of reporting services on the same server

Adam Bean

One Orange Chip

Points: 26631
More actions
December 10, 2008 at 7:41 am

#128350

Hey all,
Been doing a little reading this morning:
http://bloggingabout.net/blogs/mglaser/archive/2006/12/18/multiple-reporting-services-instances-on-one-machine.aspx
http://bloggingabout.net/blogs/mglaser/archive/2006/12/18/multiple-reporting-services-instances-on-one-machine.aspx
http://msdn.microsoft.com/en-us/library/ms159114(SQL.90).aspx
and I could use some help. Basically I have a server which is running three instances of SQL, one purely for reporting services. My plan is to install two new instances of reporting services, each one using one of the two instances of SQL and then tearing down the old reporting services instance as well as the third instance of SQL.
I'm a bit confused by what I've been reading. Do I actually need to setup multiple IP addresses? All I'm really looking to do is have two different instance of reporting services, both resolving to the same host name, simply separated by virtual directory ... http://servername/reports1 + http://servername/reports2.
Before I get underway with this and mess things up, can anyone help shed some light on this? Am I taking the correct approach in by assuming:
- Install reporting services - point to instance1
- Install reporting services - point to instance2
- Uninstall old reporting services instance
- Uninstall old SQL server instance
- Setup and configure both instances of reporting services
- Reports will resolve to http://servername/reports1 + http://servername/reports2
- Reports will be published to http://servername/reportserver$1 + http://servername/reportserver2
?
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Sam Greene SSCertifiable Points: 5252 More actions · Answer 1

Are you wanting a scale out installation - two web servers using the same report database or do you want totally separate servers? The MS article is for doing the scale out on separate servers.

Your post seems to just talk about 1 server. That first link - an additional IP is created to simulate two machines. I don't think you need to do that. I believe you should just install another reporting server and point to your other sql instance but then change the virtual directories so they don't clash with the first install.

I don't think it's necessary that you use separate sql dbs either, you could just specify custom database names.

Adam Bean One Orange Chip Points: 26631 More actions · Answer 2

Same server (for now anyways).

Anyways, I went through with the install and all is well ...

Thanks

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 3

I'm in need to accomplish the same thing on a SQL 2008 install. I installed the second reporting server instance...successful.

But how to set it up?

I don't see a 2nd set of ReportServer or ReportServerTempDB database, I don't see an option in the Reporting Services Configuration Manager, etc.

How did you implement it?

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 4

To clarify, I am trying to use multiple SSRS instances on a single database instance

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

happycat59 One Orange Chip Points: 29389 More actions · Answer 5

You can have multiple instance of reporting services on the same server. Run the SQL Server Setup program twice - first time specify , for example, Instance1 and the second time instance2 as the instance names. You only need to install SSRS (I assume that you have an existing SQL Server RDBMS you can use). When configuring the SSRS instances, you point them at the existing SQL Server RDBMS and you should end up with separate ReportServer and ReportServerTEMPDB databases - one for each instance

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 6

Not sure I follow you (sorry) or I am not communicating my intent properly.

This is a server that has the default MSSQL service and SSRS service already installed; and works just fine...

I want to add a second instance of SSRS to the existing MSSQL service so I ran the set up again and installed the new SSRS - so in my SQL Server Configuration applet I see both services up and running:

SQL Server Reporting Services (MSSQLSERVER) - the default

SQL Server Reporting Services (REPORTING) - from the second install

But there is only one ReportServer and ReportServerTempDB database in my list. There's no second Report Server databases for the new instance I just installed.

Did I miss a step or is it not even possible unless I install a second MSSQL instance as well (which I don't want to do)?

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

happycat59 One Orange Chip Points: 29389 More actions · Answer 7

Another step is needed - run the reporting services configuration manager. You can use the same SQL instance but specify different database names and you should be up and running

MyDoggieJessie SSC-Forever Points: 44486 More actions · Answer 8

Winner Winner Chicken Dinner 🙂

Thanks a million man! Working like a champ!

______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience