April 30, 2013 at 11:25 am
I would like to know from other DBAs, how do you setup your reporting server, you use a seperate server or on the same database server that has the data source for the reports?
In our environment, we intall database servers and SSIS on the same server, and install reporting service on a separate server (with database engines too, but it only hosts reportdb, and tempreportdb) for at that time reporting service is using IIS, so we think it is good to separate them because performance and security.
Now we are upgrading it to SQL 2008 R2, which will not use IIS for reporting server any more, I wonder if it is good to install all - db engine, ssis, ssrs on one box, this will save a hardware, but not sure if this will affect performance or others.
Thanks,
April 30, 2013 at 12:23 pm
We started off with all on one server because of limited use. will revisit in future if it starts to get used more heavily.
John
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply