locked
SSAS 2014: Move data directory removes administrators RRS feed

  • Question

  • If I change the location of the data directory in SSAS 2014 (using Management Studio, properties), when the service is restarted the new data directory is populated but no one is granted server admin rights on analysis services.  If I change the INI file to point back to the original data directory, the administrator accounts reappear.

    Am I missing something or is this a bug?  I've not tried to do this in other versions of SQL Server so don't know if this is consistent behavior but from reading posts, it does not appear to be so.

    • Moved by Mike Yin Friday, May 30, 2014 1:54 AM SSAS related
    Wednesday, May 28, 2014 5:47 PM

Answers

  • Hi Ira,

    According to your description, after moved the data directory of the SQL Server Analysis Services 2014, the admin permissions for user were removed, right?

    We have tested it on the tested environment (Microsoft SQL Server 2012 SP1), we cannot reproduce this issue. And based on my research, it seems no one had encountered this issue on other version. So in your scenario, please ensure that the operations when moving the data directory are correct. Here is a link for you reference.
    http://blogs.technet.com/b/mdegre/archive/2012/10/03/moving-ssas-database-to-a-new-drive-on-same-server.aspx

    If the steps in your scenario are correct, and you can reproduce this issue on SSAS 2014, we recommend you open a support case with Microsoft to check if this is a limitation in SSAS 2014. Visit this link to see the various support options that are available to better meet your needs: http://support.microsoft.com/default.aspx?id=fh;en-us;offerprophone

    Regards,
    Charlie Liao

    If you have any feedback on our support, please click here.


    Charlie Liao
    TechNet Community Support

    • Marked as answer by Ira Davis Friday, May 30, 2014 11:36 AM
    Friday, May 30, 2014 7:08 AM