Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

multiple Reporting Services servers or instances???

Posted on 2011-09-16
4
Medium Priority
?
262 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:Danny McDaniel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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:Danny McDaniel
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 2000 total points
ID: 36709034
Sure, you can have SSRS running on multiple servers too.

Greg

0
 
LVL 16

Author Closing Comment

by:Danny McDaniel
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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

597 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