I am facing the problem that I can not establish a connection to the DB stored in our company network.
To make some tests I set up a test DB on Azure and the connection to Power Apps worked like a charm.
Changes I made:
In the firewall settings I added a rule for Power Apps with the IP-Range from 52.174.88.1 to 52.174.88.255 (like I did for my test DB on Azure before)
those are my information I got from PortQry*:
The DB is stored on server:
TestServer.compnanyAddress.com
ServerName: TestServer
InstanceName: TestInstance
IsClustered: No
Version 15.0.2000.5
tcp 64432
Those are the information I use in Power Apps to connect to SQL Server:
SQL Server-Authentification
(•) Connect directly (cloud services)
SQL server name:
TestServer.companyAddress.com\TestInstance
SQL database name:
TestDB
Username:
TestUser
Password:
TestPassword
Additional Information:
In a webinar (https://www.youtube.com/watch?v=x0V0-QjSGtg) I saw this Power Apps connection to a SQL DB:
Do I have to enter my information similiar to these with the additional port? If yes how do the typed in information look like?
*PortQry: https://support.microsoft.com/en-us/help/310099/description-of-the-portqry-exe-command-line-utility
