cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mriedmueller
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

1 REPLY 1

Re: Credentials for On Prem database connection

Hi

 

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

 

Regards

 

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,933)