SSAS Tabular local access issue but can connect from other servers

Question

This was the second time this issue was happening. after a server restart, I couldn't connect to the SSAS tabular model through SSMS with neither my own username (admin) nor the service account.

However, we could all connect to the model from other servers in the network.

The icon changes to this as well :

after restarting the service a few times and restarting the server and running CHKDSK \R on all drives and getting to nowhere, it gets fixed by itself.

We are really concerned as we cannot find the root cause of the issue and don't want this to happen when we go live with the project. any idea?

Answer 1

Please ensure when you are trying to connect to SSAS or SQL locally that you open SSMS with Run as Administrator. My assumption is that your account has been given access through the local Windows Administrators group (rather than through direct permissions on your username or through different group permissions). When that is the case, Run as Administrator is required to utilize those local Administrators group permissions on the local server. This is not the case when connecting remotely to a server.