Forum Discussion
Weird gateway behaviour - SSAS MD
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
Hi Anonymous
From your description there appears to be an error/issue with the SSAS MD Server when trying to get it working via SSMS and changing the user.
I would suggest chatting to your SSAS Admin to look at SQL Profiler to see what the error is when trying to connect.
It could be that the user account has been disabled?
Hi GilbertQ
I really apprechiate your patience.
SQL Profiler shows the same error as management studio (wrong password or user):
Out of 12 users, the "change user" works for five and doesn't for seven of them. All users can work properly otherwise, so I don't think that they have been disabled. From an AD perspective, there is nothing special about the five working ones (I don't have access to the AD, but that's what the customer tells me).
Hi Anonymous
I am sure it is because the account has been disabled.
Can you ask your network admin to send you a screenshot of the domain account settings?And ask them to just check and possible re-enable the user account?