Can you install Integration Services, Reporting Services, and Analysis services on AlwaysON cluster?
I have been tasked with setting up SSIS, SSRS, and SSAS for multiple applications which will need these utilities of SQL Server. I have already a existing SQL Server 2012 Enterprise 2 node cluster using AlwaysOn technology and only running the database engine. From the little I can find online it seems that you can support the data source for these on a AlwaysOn solution, but what or how do I go about installing the actual applications? Do I need to build a separate server to host the applications while the database or data sources can reside on the AlwaysOn availability group on my cluster? Or do I need to install SSIS, SSRS, and SSAS on both nodes of my AlwaysOn cluster?
As you mentioned, SSIS and SSRS are not cluster-aware per se, but the data sources (including the SSRS databases) can be stored on an AlwaysOn Availability Group (see [here]). SSIS and SSRS aren't instance-level features at all. As such, we have installed them on a separate server with access to but not part of our SQL data farm. I do not have much experience with SSAS, so maybe someone else can address that. :