cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

URGENT Powerapps Connector Problem - Azure SQL Database

Is there a problem with the Azure SQL connector? 

 

Currently we are getting random Servor Errors "An error occurred on the Server. Server Response: Not a valid connector response."

I have removed data sources and reconnected them in studio and republish the app but its still the same.

 

This happens every couple of months

Two session id below: 

 

Session ID: 3ef537b4-d69c-461b-a0eb-83babdc1b492

Session ID: cbedc1e7-521e-4dc0-a061-3b3f0e352350

 

t19670

15 REPLIES 15
Highlighted
Frequent Visitor

Re: URGENT Powerapps Connector Problem - Azure SQL Database

I am also experiencing the same problem

Highlighted
Advocate II
Advocate II

Re: URGENT Powerapps Connector Problem - Azure SQL Database

I'm still having problems with it heres another Session Id

 

Session ID: 68b28920-9c84-42fe-b1ab-ae97cc0a3ff5

Highlighted
Regular Visitor

Re: URGENT Powerapps Connector Problem - Azure SQL Database

we are having same problems today- any idea what is going on? 

Highlighted
Advocate II
Advocate II

Re: URGENT Powerapps Connector Problem - Azure SQL Database

Been on to Microsoft "Support" after an hour of copying apps and rolling back they are no further. They have took the link to this thread. 

Will see what them come back with. 

 

This happens all too often with the SQL connector, the app will be working one day then not the next. 

 

 

 

 

Highlighted
Anonymous
Not applicable

Re: URGENT Powerapps Connector Problem - Azure SQL Database

Same issue here, it just happened Smiley Frustrated

 

[EDIT] It seems to have been temporary here, it is working again.

Highlighted
Advocate II
Advocate II

Re: URGENT Powerapps Connector Problem - Azure SQL Database

Microsoft have said to allow them some time they are esculating it.

Highlighted
Community Support
Community Support

Re: URGENT Powerapps Connector Problem - Azure SQL Database

Hi @t19670 ,

Have you taken a try to re-create a new connection to Azure SQL Server from your app?

 

Please take a try to re-create a new connection to Azure SQL Server from your app, then check if the issue is solved.

 

Some other users have also faced similar issue with SQL Connector, the Product Team is investigating this issue, if this issue is fixed, I would reply here.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Advocate II
Advocate II

Re: URGENT Powerapps Connector Problem - Azure SQL Database

That was the first thing i did before I contacted support. I even copy a new instance of the app and reconnected the datasources. 

 

Support did the same thing again and it never fixed it. 

 

I'm still waiting on the explaination, again, of why this keeps happening. No app changes, then suddenly boom, connectors don't work. This is not reliable enough.

 

 

Highlighted
Anonymous
Not applicable

Re: URGENT Powerapps Connector Problem - Azure SQL Database

Here it is back again. As the PowerApp depend a lot on SQL databases in Azure, it is unworkable now. The whole week this connector has been unstable. 

Helpful resources

Announcements
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (5,331)