I just setup an Azure SQL Server and Database. When I connect to this db using SQL Server Management Studio, my IP address is whitelisted.
When I try to connect a PowerApp to the db using the SQL Connector, I get the error basically stating "this IP address" is not allowed. The IP shown in the message is not the IP address of my computer, but rather likely the IP address of PowerApps in the cloud.
My questions are:
What is the best practice for whitlisting IP's so that my users can access the db from PowerApps?
What is the best practice for the Username and Password I enter in the SQL Connector?
Should I create a specific "PowerApps" db user with the perms I want?