Forum Discussion

frankpl's avatar
frankpl
Frequent Visitor
8 years ago
Solved

Gateway Access to Non-Domain Joined Computer Running Analysis Services

Hi, I want to connect from PBI to an Analysis Services multidimensional cube running on a standalone server not member of any domain (actually, this server is a VM running in Azure). Is this scenari...
Need Help
  • frankpl's avatar
    frankpl
    8 years ago

    I can confirm that after setting up domain and joining the computer running the gateway and SSAS to it, adding a domain account and giving it permission to the AS database, and adapting the user mapping to use that user, I got this working.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

frankpl From my understanding the simple answer is "yes" things work when the gateway is in the same domain. See here for reference. However, as mentioned in the link from that article to troubleshooting it appears you could have a non-domain joined machine as outlined here but there are certain trust relationships that have to be set up between the two domains.

I think it is fair to say that just randomly spinning up a seperate non-domain joined machine won't work, it requires a lot more in terms of creating some sort of linkage if the servers are not by default in the same domain.