question

joshobud avatar image
joshobud asked

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?
ssisssrsssas
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

This web site runs off of votes. Can you please indicate all helpful answers below by clicking on the thumbs up next to those answers. If any one answer lead to a solution, please indicate that by clicking on the check mark next to that one answer.
0 Likes 0 ·
Tom Staab avatar image
Tom Staab answered
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][1]). 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. [1]: https://msdn.microsoft.com/en-us/library/hh882437.aspx
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

H_G_H avatar image
H_G_H answered
based on my understanding SSRS SSAS will require a separate recovery strategy. Hope this help . H G
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.