Changing Analysis Service Directory

  • alex.sqldba

    SSChampion

    Points: 10221

    Hi Guys,

    I need to move the Analysis Services directory found at this location ...\MSAS14.POWERPIVOT

    Is this possible to do? I've had a read and am confused by some folk saying I have to re-install and others saying its a config option?

     

    Cheers

    Alex

  • Site Owners

    SSC Guru

    Points: 80373

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • alex.sqldba

    SSChampion

    Points: 10221

    Quick update on this as I've now resolved it. I was initially confused by the instance name of POWERPIVOT and made an assumption that it was a very specific installed module - but actually it was just the name of a secondary SSAS instance that had been installed. As a result moving the data directory was as simple as hitting properties on the instance via SSMS.

    For anyone else led down this garden path to avoid hitting a dead end I am posting a screen shot of the setting in particular.

    It required a restart of SSAS. In my case there were no actual Models or DB's created as it was an instance installed in error.

    For completeness here's the sanitised screen:

    Cheers All

     

     

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply