Share via

Azure Function App - connect to on-prem SQL

Marius Strydom 21 Reputation points
2020-11-20T03:57:06.867+00:00

Hi

Is it possible to connect to on-prem SQL from an Azure Function? From this article app-service-hybrid-connections it should be possible to set up a Hybrid Connection. However, when I go to the Networking tab, I do not have that option. Could that be because I am currently using my VS Professional Subscription or am I missing something else?

Regards, Marius

41326-azure-hybrid-connection.png

Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
0 comments
Answer accepted by question author
  1. MayankBargali-MSFT 70,981 Reputation points Moderator
    2020-11-20T04:14:36.66+00:00

    Hi @Marius Strydom

    Yes, it is possible to connect to onprem SQL from the azure function. You can refer to this document to create the hybrid connection and how it works. The hybrid connection is not supported in Consumption Plan and works with Windows OS for azure function with other plans as mentioned in this article. You need to create the function app under the app service plan.
    Reference: https://learn.microsoft.com/en-us/azure/azure-functions/functions-networking-options#matrix-of-networking-features

    Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.