cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
REX
Level: Powered On

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 

1 ACCEPTED SOLUTION

Accepted Solutions
Power Apps Staff SinanE
Power Apps Staff

Re: SQL server connection issue

The issue should be mitigated now.

View solution in original post

35 REPLIES 35
Brank
Level 8

Re: SQL server connection issue

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

Anonymous
Not applicable

Re: SQL server connection issue

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

Highlighted
Anonymous
Not applicable

Re: SQL server connection issue

Have the same issue since Monday... 

JRaasumaa
Level 10

Re: SQL server connection issue

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

Lonache
Level: Powered On

Re: SQL server connection issue

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.

rfortunato
Level: Powered On

Re: SQL server connection issue

Same problem here

tbar
Level: Powered On

Re: SQL server connection issue

SAME PROBLEM HERE!! SOLUTION NEEDED.

gax700
Level: Powered On

Re: SQL server connection issue

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

tbar
Level: Powered On

Re: SQL server connection issue

I'm using this: xxx.xxx.xx.xx\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

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,276)