Our SharePoint Farm is based on a failover SQL cluster (MS SQL 2012 Standard). The problem is, that the Analysis Services were not installed with the database engine.

If I'm understanding right, it's not supported to add/remove any features to an existing failover cluster at all?

I need some ideas/options to get the Analysis Service available to the farm.


Analysis services is a Completely different application than your clustered DB engine. you can have clustered and non-clustered apps on the same server. I don't recommend that, but its possible. With PowerPivot you point at discrete installations tbat are neither load balanced nor clustered.

I personally would stand up a dedicated server/instance for analysis services if resources are available to support it.

  • could be the dedicated instance created on the same SQL cluster like the DB engine? – Alex Nov 11 '14 at 11:33
  • Yes - you can technically deploy clustered and non-clustered applications on the same box. the cluster is just a "service" and applications that are deployed to use that service. – Jesus Shelby Nov 12 '14 at 20:40
  • hm ok, I'll try to add a additional instance with Analysis Services. Thanks ! – Alex Nov 13 '14 at 6:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.