Forum Discussion
Unable to connect to SSAS Tabular from Service
We deleted the users from the gateway, and re-added them. Then the issue went away. Interesting that the problem occurred following a team wide reseting of passwords. Seems like the updated paswords didn't propogate to the Data Gateway.
Hey Steve. Sounds like a different issue to the other thread. That issue looked to be a problem with 2 different account domains passing security between themselves.
Your one appears to work for a period of time then stop working. It would seem to me that if you work out what circumstances cause this temporary fix then perhaps the cause will become clear. Something I would first look into is what User/Pass are you using with the gateway and could that have any changes. For example in some occasions a username might be assigned as authentication but then the password gets changed. The stored password then fails.
We deleted the users from the gateway, and re-added them. Then the issue went away. Interesting that the problem occurred following a team wide reseting of passwords. Seems like the updated paswords didn't propogate to the Data Gateway.
The gateways will remember what password you stored against the user credentials and should check them against the current password in AD. If there is an update, the stored credentials will mismatch from the newly updated passwords in AD.
I'd recommend making use of service accounts with non-rotating passwords if possible.