cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Unable to run app with error "your app needs permission to use : SQLserver"

I have the same issue but only on the web browser and Ctrl-F5 doesn't change anything. The mobile app works fine no problem on that side it's really weird.

 

 

Highlighted
Advocate II
Advocate II

Re: Unable to run app with error "your app needs permission to use : SQLserver"

@Romain_Pham, Did you try a different browser?
Highlighted
Frequent Visitor

Re: Unable to run app with error "your app needs permission to use : SQLserver"

Hi @Hairy_Drumroll  i tried with Chrome, Firefox, Edge all same message and that to all my user trying to access the app through web browser including me owner of the app. But by Phone no issue the can connect and  interact interact the app without problem (consult, update and add record).

 

Should I remove the connection and add it back ?

Highlighted
Advocate II
Advocate II

Re: Unable to run app with error "your app needs permission to use : SQLserver"

Sorry, outside of my skill set now.

Highlighted
Frequent Visitor

Re: Unable to run app with error "your app needs permission to use : SQLserver"

I re oppend my app and find out a old SQL Server connection on premise was still there and while i desactivated the on premise gateway so i guess that was this causing the issue.

 

Now no more issues

Highlighted
Advocate I
Advocate I

Re: Unable to run app with error "your app needs permission to use : SQLserver"

How to fix "Your app needs this connection. Please edit your app to add it back."

1. Remove all possible sql conections, which are linked to the app. Take care. The SQL Connection should all be deleted. Sometimes the System hangs and does not clear a sql connection.

2. Remove Link to Flows, which uses these sql connection

3. After this step i take a little break. Maybe the background needs some time.

4. Save, clear Browser data. Try to start up in run mode. The message should have disappeared.

5. Open your app. Save and Publish it again.

6. Add the connection threw the PowerApps Portal (View/Connection/Add Connection).

Highlighted
New Member

Re: Unable to run app with error "your app needs permission to use : SQLserver"

Yes, I struggled with this error all last week and could not publish, and therefore could not Export the latest changes to the app.  Prior to the error I probably Published 10 times over a 2 week span of constant developing on the app.  Anyways, after racking my brain and searching for answers with no avail, I realized that the problem started after I started using Power Automate Flows, but it was not the flows that caused the problem, it was that I changed Environments on my PowerApp to use the same environment as the Flow environment and that is when the problems seem to occur.  When I went back to original environment that I initially created my SQL Connections with for the app, the "Permission" errors went away.

 

This is my experience, I then re-added my changes to the last good saved app backup files from when I worked in the good environment, and things are working fine now.  I do not understand exactly the details of why, but that is how I was able to get around the problem and I hope this can help someone out there,  because it took me at least several days to figure this out.

Helpful resources

Announcements
secondImage

Demo-Extravaganza 2020

Check out these cool Power Apps & vote on your favorite!

secondImage

Community Highlights

Check out whats happening in Power Apps

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

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