URGENT Powerapps Connector Problem - Azure SQL Database

(0) Share

Report

Posted on by t19670

120

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

Categories:

Building Power Apps

I have the same question (0)

All responses (15)

Answers (0)

Sort by

tlawsonpinewalk 48 on at

Like
a
(0)

Report
Copy link

Link copied!

I am also experiencing the same problem

Was this reply helpful? Yes No
t19670 120 on at

Like
a
(0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
Zlatkododig 8 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
t19670 120 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Same issue here, it just happened

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

Was this reply helpful? Yes No
t19670 120 on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No
t19670 120 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
EvanChakiMSFT Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

rbsk, are you still having the same issue, can you post a session ID?

Was this reply helpful? Yes No