Safely giving Azure SQL Access Without Specifying IP Addresses?

Matt Dorsey 151 Reputation points
2022-07-13T02:15:22.41+00:00

I’ve got an azure sql database that my static web app/azure functions are able to access because of the selected networks I’m specifying with IP addresses. This is fine during development, but once it moves to production customers will begin using it whose IP addresses I won’t know and won’t be able to add to the firewall settings to give them access (even if I did this wouldn’t be a sustainable option).

How can I safely give database access to anyone without asking them for their IP address? (To clarify, the web app will be calling the Azure function that will be making calls to the database.)

Thanks!
Matt

220186-screen-shot-2022-07-12-at-91010-pm.png

Azure SQL Database
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
3,995 questions
0 comments No comments
{count} vote

1 answer

Sort by: Most helpful
  1. Alberto Morillo 32,706 Reputation points MVP
    2022-07-13T02:34:45.127+00:00

    You can use a managed identity or access token to allow the Azure Function to connect to Azure SQL Here is an example of how to do it.

    1 person found this answer helpful.
    0 comments No comments