Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connection to on-premise SQL Server - Invalid credentials



I've just installed the On-Premise gateway on my laptop for testing purposes and have added a SQL Server instance to the gateway.



 All good so far, but when connecting to the source I get the error below (Pressing the "Default" dataset):




It works perfectly in Power BI (Using the same user there).

So I have a domain account (Given by my organization, not AAD) and an account (Office 365 user). Shouldn't I be able to connect to the source when I have used the domain account credentials in the data source settings? Or do I have to link these accounts in some way?




Same issue for us, another post related is here:



To answer your question @Vicky_Song re: adding a machine with IP I have tried that with our current problem and it still comes up with the same credentials issue problem that @Anonymous initially had.



No updates to give. I put a help ticket in February and after several month of sending tech support trace data they were not able to find the issue. I have finally given up on the project and they have closed the help ticket. Maybe someone will figure this one out for us.


Not applicable

What's the status right now? I'm having the same problem while trying to make a azure sql db connection. 

@Anonymous wrote:

What's the status right now? I'm having the same problem while trying to make a azure sql db connection. 

This thread is a year old, if you are on the most recent version of the data gateway you should be all set.


Otherwise if it's not working for you it's worth putting in a support ticket:

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,460)