Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Looking For Your Opinions-How do YOU install SSRS?

Author  Topic 

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-09-16 : 11:17:05
As part of trying to figure out where the report definitions are stored from my previous question (which as of yet is not answered) I was finally given admina ccess to the server where we installed SSRS and found that we are using our soon to be production database server as the location of the of the Database Connection when they configured our report server. For a bunch that is very nervous about their application performance, I would have assumed that they would have installed SQL Server on the same server as reporting services to reduce load on production.

My question to all of you is:

Are there issues or benefits to installing SSRS on a server other than where the database for SSRS resides? Is it more a matter of cost?

John

"The smoke monster is just the Others doing barbecue"
   

- Advertisement -