Forum Discussion

swenck's avatar
swenck
Frequent Visitor
10 years ago
Solved

On Premises Data Gateway - PBI Service cannot connect to Local On Premises SSAS Instance

I have SQL Server 2014 Developer Edition installed on my laptop (local machine - not connected to a domain).  SSAS is in MD Mode.  Successfully installed and configured the On Premises Data Gateway a...
Need Help
  • Anonymous's avatar
    Anonymous
    10 years ago

    Hi swenck,

    Yes, the scenario you describe is not supported. Both gateway and SSAS server need to be on domain-joined machines.


    Thanks,
    Lydia Zhang

  • swenck's avatar
    swenck
    10 years ago

    Thanks Lydia.

swenck's avatar
swenck
Frequent Visitor
10 years ago

Hi Lydia - thank you for the response.  Just so I am clear then - the scenario I described  above is not supported if my laptop is not in a domain.  (It is only in a Workgroup). 

 

You see - I am a remote user in my company and we do not authenticate to a domain when logging into the the machine, rather we log in locally to the machine.  I have SQL Server Developer Edition installed locally but again the computer is not part of a domain.  So I assume there is no way to get the On Premises Data Gateway to connect to my local SSAS instance even if the Gateway is configured on this machine?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi swenck,

Yes, the scenario you describe is not supported. Both gateway and SSAS server need to be on domain-joined machines.


Thanks,
Lydia Zhang

  • swenck's avatar
    swenck
    Frequent Visitor
    10 years ago

    Thanks Lydia.

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi swenck,

      It is better that you mark helpful replies rather than your own reply as answer. That way, other community members could benefit from the actual solution.

      Thanks,
      Lydia Zhang