Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Credentials for On Prem database connection

Hi everyone,

I have created a connection to an on prem sqlserver database using our gateway.

What intrigues me is that I have to use a fixed account and password in defining the connection.
I would have expected that The credentials used will be taken from the current user of the power app.
That way security could be imposed on the data delivered to powerapps.


Am i mistaken or is this something to be expected in the future?


Thanks in advance, Michael


Re: Credentials for On Prem database connection



I guess this is the expected behaviour. You control who can use the gateway and therefore, the service account used by the connection. I believe as the connection on prem is using a local account, then it can't use your cloud identity




Helpful resources


PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.


Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Top Community Contributors for September  2019

Top Community Contributors for September 2019 🎉🎉

Let's thank our top community contributors


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Users Online
Currently online: 188 members 5,438 guests
Recent signins:
Please welcome our newest community members: