Post reply

Changing Analysis Service Directory

  • June 28, 2020 at 6:09 pm

    #3765381

    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

  • June 29, 2020 at 6:10 pm

    #3766258

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

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

  • June 30, 2020 at 2:06 pm

    #3766444

    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 2 (of 2 total)

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