We a provisioning a new SQL Failover Cluster. We have successfully configured the SQL instance, and have moved on to configuration of the PowerPivot for SharePoint instance. We run the configuration wizard, and create a new failover cluster. However when the install completes, the resultant Analysis Services instance is in Multidimensional Mode (Compatibility level 1100) rather than in SharePoint integrated mode.
After the configuration had completed, the SSAS instance is in the wrong mode.
This works fine on a non-clustered instance in a VM lab, anyone else experienced a similar issue and hopefully has a fix?