question

MariusStrydom-4071 avatar image
0 Votes"
MariusStrydom-4071 asked MariusStrydom-4071 commented

Azure Function App - connect to on-prem SQL

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-functionsazure-webapps-hybrid-connection
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MayankBargali-MSFT avatar image
0 Votes"
MayankBargali-MSFT answered MariusStrydom-4071 commented

Hi @MariusStrydom-4071

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://docs.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.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

This perfect - thanks for the quick response.

0 Votes 0 ·