Forum Discussion

sanjoyleo's avatar
sanjoyleo
Helper I
8 years ago
Solved

Windows Auth login failure for SQL Server

Hello All,   Admin has created a Gateway and used Windows Authentication to create a data Source  fro SQL Server . Note Gateway installed in a VM . I can see the data source connection is successfu...
Need Help
  • sanjoyleo's avatar
    sanjoyleo
    8 years ago

    Thanks !

     

    What I found is if I use Server-Name (instead of IP) in PBI Desktop , I have  to use same Server-Name in the data-source under the Gateway.

     

     

v-xjiin-msft's avatar
v-xjiin-msft
Solution Sage
8 years ago

Hi sanjoyleo,

 

First, it is supported to use Windows Authentication in Direct Query mode.

 

Then for your error. As it said, your Power BI Desktop cannot recognize this AD account. Since the Gateway and data source are in a VM. And you are creating Power BI reports on your own machine. Right? You should verify that if your own machine and this VM are in one same domain or if you can ping this VM from your own machine.

 

Then if your machine and this VM are in different domins, you need to establish a trust relationship between the two different domains.

 

For more details, you can refer to this relevant thread:

https://community.powerbi.com/t5/Desktop/Connecting-to-SQL-Server-using-Windows-Authentication-from-a/td-p/91989 

 

Thanks,
Xi Jin.

  • sanjoyleo's avatar
    sanjoyleo
    Helper I
    8 years ago

    Thanks !

     

    What I found is if I use Server-Name (instead of IP) in PBI Desktop , I have  to use same Server-Name in the data-source under the Gateway.