cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

Azure SQL Best Practices?

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. 

 

2018-09-14_15-21-20.png

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Azure SQL Best Practices?

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Community Support Team
Community Support Team

Re: Azure SQL Best Practices?

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

Re: Azure SQL Best Practices?

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

Community Support Team
Community Support Team

Re: Azure SQL Best Practices?

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

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

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

SecondImage

Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 207 members 4,417 guests
Please welcome our newest community members: