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.

1 Answer 1


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
    Commented Nov 11, 2014 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. Commented Nov 12, 2014 at 20:40
  • hm ok, I'll try to add a additional instance with Analysis Services. Thanks !
    – Alex
    Commented Nov 13, 2014 at 6:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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