Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weird gateway behaviour - SSAS MD

Hi all,   We have a solution that uses SSAS Multi Dimensional Cubes with Power BI service. It works for many of our customers, but with this recent customer, I cannot get it running.   I configur...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    After many more hours of investigation, we finally found a working solution.

     

    The service "SQL Server Analysis Services (MSSQLSERVER)" was running under the default user "NT Service\MSSQLServerOLAPService". Changing the service user to a domain service user (e.g. domain\svssas) made all issues go away. I still don't fully understand why, but we are just glad it works.

     

    Thank you GilbertQ for your support.

     

    Best,

    Marco

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

I would expect it still to work when using a domain admin, as long as the EffectiveUsername is being correctly used?


What version of SSAS MD is being used, if it is an older version that might be the issue?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi GilbertQ 

    Thank you for your response. The SSAS Version is 2019 (15.0.32.55).

    I also noticed that the "Change User" function in management studio does not work. It states that the username or the password is wrong:

    Since the gateway is doing something similar like "change user" (I suppose), could this have something to do with it? And if so, how do I fix it?

    • GilbertQ's avatar
      GilbertQ
      Super User
      4 years ago

      Hi Anonymous 

       

      Yeah that does seem to be an issue and to fix it I would search for now to get EffectiveUsername on SSAS MD?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi GilbertQ 

        Sorry, but I guess I need some more help. How do i get EffectiveUserName on SSAS MD?