Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 11:07 AM
Points: 1,783, Visits: 3,231
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,
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: 2 days ago @ 7:26 AM
Points: 68, Visits: 419
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
Post #1448191
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse