Logic Apps, Azure Function accessing a SQL Database with IP restriction

Question

I have a Logic App and Azure Function in my Azure tenancy which needs to access a SQL Database in a third party company's Azure tenancy. The Azure SQL Database is owned and managed by a third party company who require a public IP to restrict access.

My understanding is that Logic Apps and Functions do not have a static outbound public IP address. What solutions do I have to access the SQL Database in Azure in this scenario?

Initial thoughts are to proxy the request from a Logic App or Azure Function via a proxy server (IAAS) in Azure. However not sure if this will work with SQL Database — Tariq
– Tariq, Commented Nov 13, 2018 at 17:48

Murray Foxcroft · Accepted Answer · 2018-11-13 17:56:48Z

1

You would need to ask the 3rd party to open up the Azure IP range for the relevant Data Center (region).

You can find the most update to date list here.

Alternatively, you need to move your functions to an Isolated Plan, in which case, you can then assign a static IP. From the docs:

Dedicated IP addresses If you need static, dedicated IP addresses, we recommend App Service Environments (the Isolated tier of App Service plans). For more information, see App Service Environment IP addresses and How to control inbound traffic to an App Service Environment.

You can also query the inbound and outbound IP addresses for an app service plan.

answered Nov 13, 2018 at 17:56

Murray Foxcroft

13.9k7 gold badges66 silver badges97 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Tariq Over a year ago

Thanks Murray. The 3rd party are hosting their database in Azure, however they are only willing to open it up to a single static IP. Looks like the above will work for Azure Function. Need to look for a solution for a Logic App

Murray Foxcroft Over a year ago

You can get your function to start a logic app... not ideal but may be a solution. github.com/MicrosoftDocs/azure-docs/blob/master/articles/…

Thomas Over a year ago

I would suggest to have one function doing the SQL part and having the logic app calling the function, this way is easier.

Collectives™ on Stack Overflow

Logic Apps, Azure Function accessing a SQL Database with IP restriction

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related