Solved

multiple Reporting Services servers or instances???

Posted on 2011-09-16
4
257 Views
Last Modified: 2012-05-12
We have SQL 2005 server with RS already installed and being used by an app (Noetix if it matters) and now we have another app that needs to use RS.  

I ran into this before when my manager wanted Team Foundation Server installed and I found that even if I installed RS on another server and used a different database, it still clobbered the original reporting config on the SQL server.

I'm just a sysadmin and don't know what I'm talking about so be gentle. ;)

is there some way that we can have 2 different apps that need RS hosted on the same SQL server without them using the same RS instance (if that's the right term)?
0
Comment
Question by:danm66
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:JestersGrind
ID: 36552563
Yes, you can have multiple instances of SSRS on the same server.  This MS link talks about how to do it.

http://msdn.microsoft.com/en-us/library/ms403426%28v=sql.90%29.aspx

Greg

0
 
LVL 16

Author Comment

by:danm66
ID: 36595692
thanks for the link!

The article mentions having multiple instances on the same SQL server, so I'm wondering if I can have RS installed on the SQL server using one instance and another instance running from RS on a separate server?
0
 
LVL 21

Accepted Solution

by:
JestersGrind earned 500 total points
ID: 36709034
Sure, you can have SSRS running on multiple servers too.

Greg

0
 
LVL 16

Author Closing Comment

by:danm66
ID: 36934577
Thanks for the help.  I had some issues with it not allowing me to view the /reports webpage but it, apparently, needed time after installatio to complete.  I was getting various errors after installation but the next day another admin checked and it was working.  
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
A recent questions about how to add SSRS named instances, couldn't find any that talks about SQL server 2008, anyway I decided to help by creating some screen shots. The installation is straightforward, you just pop the SQL server 2008 installati…
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question