Unanswered

Can't enable enhanced SQL Server connector

(1) Share

Report

Posted on by Community Power Pla... Microsoft Employee

When I go to Advanced app settings, I can't enable the Enhanced Microsoft SQL Server Connector. I get the error "Your app has a SQL data source - you must first remove any existing SQL data sources before you can toggle this feature". I've opened View > Data sources, and deleted all SQL Server sources. I've also deleted the specific SQL Server connector from Powerapps > Data > Connections. I've left it overnight in case jobs/sync's need to run but the error still appears. I have other connections in other powerapps to SQL Server so I can't remove all SQL Server connections as it will break those apps. Also when I now go to edit the app, I get a permissions issue saying I need to re-add the SQL Server connection, with an 'Allow' button greyed out.

How can I enable this setting?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

v-siky-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous ,

I have made a test on my side, once I delete all SQL Server Data sources, the feature can be toggled on.
So the cause of your issue may be that you haven't deleted all SQL Server Connectors.
Can you confirm that is there any flow which contains SQL Server Connector within your apps?

Best regards,
Sik

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-siky-msft ,

No I'm not using Flow or any other SQL Server connectors in the app.

Cheers

Was this reply helpful? Yes No
PowerAppMatt 28 on at

Like
a
(0)

Report
Copy link

Link copied!

I also have this same problem. Did you end up resolving it? Any help is appreciated, thanks!

Was this reply helpful? Yes No
Bradleyts 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Has anyone found a solution to this?

Was this reply helpful? Yes No
dmanoni11 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I have this same issue - I removed all SQL Datasources and Flows. There is nothing left to remove. I have saved and reloaded many times. - Still tells me I have an SQL data source.

Was this reply helpful? Yes No
madalin97 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

This issue still persists. I also removed all my SQL datasources and still have this error when trying to enable enhanced SQL Server connector.

Any help would be appreciated.

Thanks.

Was this reply helpful? Yes No