I am in the process of configuring BI stack include following components on Primary site.
layer 1: Web application front tire Servers
Layer 2 SSAS/ SSRS
Layer 3: ETL/ SSIS /MDS(Master data service and Data quality service
Layer 4 database servers
similarly we have to configure DR environment identical to primary
1.While installing MDS service there is a option to configure databases remote server or local server. This database will contents staging data what is the best practice to hosting data base in local server(layer 3) or database servers (layer 4).
2. There is no option for configure IIS web services remotely(Layer 1) and by default set to install locally (layer3). In this situation how should we use layer 1 web frant servers . Do we have to configure other installation of IIS web services configuration on Layer 1?
Highly appreciate expert advice .