Click here to Skip to main content
0 members

Moving Analysis Service on a SQL 2008R2 Failover Cluster

Rate this:
0.00 (No votes)
Please Sign up or sign in to vote.
0.00 (No votes)
12 Oct 2011CPOL 14.1K   1
It’s not possible to add or remove features on a SQL cluster under 2008 R2. Here's a workaround.

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

  1. Open Management studio and log into Analysis Services for the cluster instance
  2. Right click on the server and click properties

  3. Edit the following path's to reflect the new locations


  4. Log out of Management studio
  5. Stop Analysis Service
  6. Copy the OLAP folder to the new path
  7. In the registry go to
    . Edit the Image path of F:\OLAP\Config to reflect its new path G:\OLAP\Config
  8. Open the OLAP\Config\msmdsrv.ini file and edit the paths to reflect their new locations
  9. 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.
  10. 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.


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Chris Maunder
Founder CodeProject
Canada Canada
Chris is the Co-founder, Administrator, Architect, Chief Editor and Shameless Hack who wrote and runs The Code Project. He's been programming since 1988 while pretending to be, in various guises, an astrophysicist, mathematician, physicist, hydrologist, geomorphologist, defence intelligence researcher and then, when all that got a bit rough on the nerves, a web developer. He is a Microsoft Visual C++ MVP both globally and for Canada locally.

His programming experience includes C/C++, C#, SQL, MFC, ASP, ASP.NET, and far, far too much FORTRAN. He has worked on PocketPCs, AIX mainframes, Sun workstations, and a CRAY YMP C90 behemoth but finds notebooks take up less desk space.

He dodges, he weaves, and he never gets enough sleep. He is kind to small animals.

Chris was born and bred in Australia but splits his time between Toronto and Melbourne, depending on the weather. For relaxation he is into road cycling, snowboarding, rock climbing, and storm chasing.

Comments and Discussions

GeneralThank you! Pin
Cary Davis30-Apr-13 10:37
memberCary Davis30-Apr-13 10:37 
Hacking the registry to change a startup parameter! I guess we do what we've gotta do. Thanks for the post.

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.