Showing results for 
Search instead for 
Did you mean: 
New Member

App user cannot "allow" SQL connection

I have an app using an on-prem SQL Server 2012 database set up with an on-prem gateway.  I use a basic login for the connection and I have admin permissions on the gateway.  Everything works well for me when using the app.


When I share the app with other users they are prompted to allow the SQL connection, but the "Allow" button can not be clicked.  


I found some info here :


"If you create and share an app that includes data from an on-premises source, the on-premises data gateway itself and certain types of connections to that gateway will be shared automatically. For any connection that isn’t shared automatically, you can share it manually (as the previous section shows) or let the app prompt users to create their own connections."


I expected the connection to be shared automatically.  Do I need to also share the connection with every user I share the app with in this situation?








Community Support
Community Support

Hi @bjnodello,


Some questions:

1. Is this happening to all the users that you shared the app with?

2. Would you please create another app with a different database in SQL and have a test?




Community Support Team _ Mona Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you Mona,


1. Yes, this is happening to "all" users (I've only shared it with 2 others)

2. I will try to get to this today and get back to you.






Sorry for the delay.  I have been doing some testing.


So, I created a new app with a different database (auditdb) and appear to have no issues with the new app.  


Something odd did happen though.  I wanted to test the original app with more users.  When they access the new app they are prompted to allow access to the auditdb database, which is not a connection in this app.  When you enter the app an "Unknown error occured" warning comes up.


I have checked in the app and the correct database (sortdb) is showing as a datasource. I also check under details for the original app in the app list and it shows the correct connection to the sortdb.

Not applicable


I just run across something similar. I am using SQL Server connection to an Azure DB and when I sent the link to one of my co-workers to test the app they are not prompted with any box to allow the connection and while using the app no data is returned.

I have shared the app with them giving them 'Use + Edit' permissions, and I have checked on the Connection itself, that being shared with them as well.

Is there anything I'm missing? This is not the first time I am sharing the apps like this and it always worked before.


Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,176)