The issue we had was our F drive on the SQL cluster needs to go and is being replaced by G. F had a hardware failure and must go away. Unfortunately Analysis Services is installed on F. It’s not possible to add or remove features on a SQL Server cluster under 2008 R2. So removing it an reinstalling it is not an option. The Microsoft documented solution is to uninstall the nodes and re-install them. Sorry Microsoft, not good enough me.
Here is how my step by step of how I hacked out the solution.
Moving Analysis Service on a SQL 2008R2 Failover Cluster
From the Active Node
- Open Management studio and log into Analysis Services for the cluster instance
- Right click on the server and click properties
- Edit the following path's to reflect the new locations
- Log out of Management studio
- Stop Analysis Service
- Copy the OLAP folder to the new path
- In the registry go to
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\MSSQLServerOLAPService. Edit the Image path of F:\OLAP\Config to reflect its new path G:\OLAP\Config
- Open the OLAP\Config\msmdsrv.ini file and edit the paths to reflect their new locations
- Repeat step 7 on the other SQL clustered nodes (6 is omitted as their files don't exist on the other nodes until they become active nodes.
- Start Analysis Services on the active node
Now with analysis services running you should be able to rename the original folder to something like f::\OLAP-BAK. If you can you have succeeded. If not you missed something or Microsoft changed something since I wrote this article.
You should also perform a failover to ensure this all worked.