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 https://powerapps.microsoft.com/en-us/tutorials/share-app-resources/ :
"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?
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?
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.
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
Learn how to build the business apps that you need.