on-prem sql server setup

[dlbacas]

scenario: successfully installed and tested an OnPrem Gateway in my laptop (Apps connecting to an OnPrem SQL Server.)

now setting up the the Gateway to the actual server, encountered the following errors:

what may be the reason and can't seem to successfully setup the gateway even upon signing in?is it firewall or security-related?

[dlbacas]

Hello PowerApps Community,

I just want to know if there are any available Network with Firewall/Security Diagram to an On-Premise PowerApps setup?

[v-micsh-msft · Accepted solution]

Hi @dlbacas,

From the error message, it should be the security settings under the server side that blocks the connection.

Please follow the document below to configrue the firewall settings:

Understand on-premise data gateways for Microsoft PowerApps

Refer to Configure the firewall or proxy part.

Some more readings:

Limits and configruation in Microsoft PowerApps

Regards,

Michael

[dlbacas]

hello @v-micsh-msft

thank you for the reply

just relayed the firewall/security configuration info to our Security group.