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

Anonymous's avatar
Anonymous
Not applicable
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 

 

The reason it works is because when the service is running under a local system account such as "NT Service\MSSQLServerOLAPService" it cannot query Active Directory.


When you change it it to use a domain account, as you did above it allows it to then query Active Directory and lookup the users!