cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
REX
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 

35 REPLIES 35
gax700
Frequent Visitor

Same problem here and this time not related to named instances... and it's friday... Cat Frustrated

I already tried restarting my On-Premise Data Gateway and it doesn't seem to work for me. 

If you were seeing this issue : "Invalid Mashup Expression using supplied values. inner exception: An error happened while reading data from the provider: 'Instance failure.'" - we have deployed a fix for this and things should be working now.

Can folks check and let us know if they are still seeing the issue?

REX
Frequent Visitor

Thanks Im back up and running!

KMI-Keith
Advocate IV
Advocate IV

I am having this error also now, what is it that created this issue?

lero
Helper I
Helper I

 

Helpful resources

Announcements
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.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

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.

Top Solution Authors
Users online (3,074)