Answered

Azure SQL Best Practices?

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

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?
- Is there another best practice?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @ericonline,

"

You should use these addresses if, for example, you must whitelist IP addresses for an Azure SQL database.

"

Which could be found under:

Limits configuration

For a step by step guide, see:

PowerApps and Azure SQL Database, step by step guide

Regards,

Michael

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Great resources!

Continuing this question:
Is whitelisting the only method for allowing API access to a SQL db or are there other methods to use with PowerApps?

Thank you

Was this reply helpful? Yes No
Verified answer

v-micsh-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

I think whitelisting is the only way to make the SQL API to work.

As the document states:

"

Calls made from an API connected through an app (for example, the SQL API or the SharePoint API) come from the IP address specified later in this topic.

"

Regards,

Michael

Was this reply helpful? Yes No
ChinoDoesStuff 48 on at

Like (0)

Report
Copy link

Link copied!

I know this is a pretty old thread but just to add my two cents worth here is a link to my tutorial on getting started with Power Apps and Azure SQL. It covers the preliminary stuff like getting setup in SQL Management Studio and creation of your database in Azure. Hopefully this help anyone who might be struggling with this topic -

Was this reply helpful? Yes No