Forum Discussion

jertel's avatar
jertel
New Member
8 years ago

Can't get Power BI to accept windows login for sql credentials

I am trying to get Power BI to use windows logins to access our sql server connection rather than a direct sql login.  Direct sql login woks fine through the gateway.  Windows login does not.  We hav...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

jertel,

Are you able to connect to SQL Server using Windows login via SQL Server Management Studio in the gateway machine? If you still get same error, I am afraid that you should establish a trusted relatsionship between the two domains, which is necessary for Windows login.

Regards,
Lydia

jertel's avatar
jertel
New Member
8 years ago

No if she tried to connect via ssms on her windows it would be the domain her local box is on which isn't the domain the sql box is on.  Power BI has the credentials to use that are valid on the sql box but it doesn't appear to be trying to log in it just instantly fails without a delay. Is there no way for windows login to work without the cloud domain trusting the local domain?

 

That is what I thought the issue was but I am just hoping there's some way around it as the network admin says the only way to create the trust is to basically redo the domain controllers.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    jertel，

    Yes. This is a Windows authentication issue in SQL Server. You would need to create trust relation between two domains to make Windows login work.

    Regards,
    Lydia