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.
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" |
|
|
|
|