Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

SQL server connection issue

Good Day 

Over the weekend one of our Powerapps appliactions stopped working we are running Power apps SQL connector through a on premises gateway to SQL Server 2012, the gateway seem to be fine the PowerBI reports runlike nothing has changed. 

When we go to the powerapps web application and test the connection we get an error

"Credentials are missing or not valid. inner exception: Credentials are required to connect to the SQL source." 

but the it was working 5 days ago 


The Gateway log says
Non-gateway exception encountered in activity scope: Microsoft.Data.Mashup.MashupCredentialException (0x80004005): Credentials are required to connect to the SQL source.


We are using the correct login details into the connector it is like it is not passing them on the the server when trying to connect?

Anyone had this issue or know where to start looking 


Accepted Solutions

The issue should be mitigated now.

View solution in original post

Advocate III
Advocate III

Hello can you please give us a solution?  Our applications are stopped because of this.

Not applicable

Have the same issue... asked at monday but there is still no reaktion by anyone.

Not applicable

Have the same issue since Monday... 

Memorable Member
Memorable Member

Just lost connectivity to all my SQL sources with On-Premise Gateway as well.


No clue if it's a Windows Update that's caused this but it would be nice to have a solution...

And it looks like I'm having the same issue:  Credentials are missing or not valid. inner exception: Credentials are required to connect to the SQL source.  Suddenly happened today.  Working late yesterday.

Regular Visitor

Same problem here


Frequent Visitor

Same problem here guys...Smiley Sad


Just a question: does your SQL server has an named instance? (ie SQLSERVER\INST01)

I've tried to create a connection to a SQL Server with a default instance and it works... bah...

Regular Visitor

I'm using this:\PMTLMSSQLDEE01 (x=#). 

No issues until today.

Logged onto server, reinstalled new Gateway update, added existing gateway on server, logged to PowerApp and still has same credential error message.

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,249)