Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

reporting server, separate or not Expand / Collapse
Posted Tuesday, April 30, 2013 11:25 AM


Group: General Forum Members
Last Login: Monday, September 19, 2016 10:45 AM
Points: 1,952, Visits: 3,672
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.

Post #1448160
Posted Tuesday, April 30, 2013 12:23 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, February 19, 2016 8:02 AM
Points: 73, Visits: 444
We started off with all on one server because of limited use. will revisit in future if it starts to get used more heavily.

Post #1448191
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse