Right now both SSRS, SSAS and SQL Server Engine are on the same server. We are using 2008R2 Enterprise. We are thinking to upgrade to SQL Server 2012 or 2014. and We want put on separate serve the SQL Engine and SSRS,SSAS on SQL Server 2012 or 2014.
What we want is:
Server 1 for SQL Server Engine
Server 2 for SSRS and SSAS
My questions are:
- How they talk each other(the two Servers)?
- Where the cube for SSAS stored?
- Where the report builder build report?
- Can you give my high level explanation how server 1 and server 2 interact or direct me some document I can read?