cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Connection to on-premise SQL Server - Invalid credentials

Hello!

 

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

 

 Capture.PNG

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

 

Capture.PNG

 

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

So I have a domain account (Given by my organization, not AAD) and an on.microsoft 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?

 

 

13 REPLIES 13

Same issue for us, another post related is here: https://powerusers.microsoft.com/t5/PowerApps-Forum/SQL-server-connection-issue/m-p/35856#M14811

 

 

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.

 

Anonymous
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: https://powerapps.microsoft.com/en-us/support/

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (2,553)