Forum Discussion

pauste1's avatar
pauste1
Frequent Visitor
9 years ago
Solved

Unable to connect to domainSQL Server with Windows Auth via data gateway on non-domain server in DMZ

The issue: A SQL Server data source in the Power BI service with Windows Authentication cannot connect to the on-premises SQL Server in a domain through an On-Premises Enterprise Data Gateway when t...
Need Help
  • pauste1's avatar
    pauste1
    8 years ago

    The technician from a support call with Microsoft eventually stated it was required to install the gateway on a domain-connected server to enable Windows Authentication modes. I'm not sure if the Microsoft technician was just opting for an 'easy' answer or it's a genuine requirement that is not documented anywhere that I saw. So we decided it was an 'undocumented requirement' of the Gateway for that architecture and security configuration.

Koumos's avatar
Koumos
New Member
8 years ago

Hello Pauste1, did you found any solution on the above Problem? I have the same problem with these services!!!

pauste1's avatar
pauste1
Frequent Visitor
8 years ago

The technician from a support call with Microsoft eventually stated it was required to install the gateway on a domain-connected server to enable Windows Authentication modes. I'm not sure if the Microsoft technician was just opting for an 'easy' answer or it's a genuine requirement that is not documented anywhere that I saw. So we decided it was an 'undocumented requirement' of the Gateway for that architecture and security configuration.