Azure Functions connect to on-premises SQL Server

Question

I am trying to connect my new Azure Function to an on-premises SQL Server database. The Microsoft docs mention that this is possible, but I have not been able to figure it out nor have I seen any tutorials about specifically setting up a on-premises db with Azure Functions.

I want to do something similar to this tutorial.

public static async void Run(TimerInfo myTimer, TraceWriter log)
{
    var str = ConfigurationManager.ConnectionStrings["on-prem-connection"].ConnectionString;

    //open connections and call db here - I know this
}

Can I do it in a similar way to the video above where I set up a connection string and then reference that connections string in the Azure Function. If so how is that done.

Thanks you.

Are you asking how to do the code part in Azure Functions or how to connect to on-premises? — Martyn C
– Martyn C, Commented May 23, 2016 at 21:43

Boris Lipschitz · Accepted Answer · 2016-05-24 00:06:13Z

9

You would need to use something like Hybrid Connection. Check out the following link. I hope it helps: https://azure.microsoft.com/en-us/documentation/articles/web-sites-hybrid-connection-connect-on-premises-sql-server/

answered May 24, 2016 at 0:06

Boris Lipschitz

9,5766 gold badges55 silver badges64 bronze badges

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

1 Comment

Jack Marchetti Over a year ago

Wouldn't the latency cause some issues or does Hybrid Connection make the connection fast enough?

Leon Africa · Accepted Answer · 2019-04-08 08:34:40Z

0

Possible but using Azure function as deployed under App Service Plan.

Go to "Platform Features" and select "Networking" - there you will get the option to setup the Hybrid connection for the Azure Function.

edited Apr 8, 2019 at 8:34

answered Apr 8, 2019 at 8:24

Leon Africa

6498 silver badges12 bronze badges

Comments

Osman Taskiran · Accepted Answer · 2020-02-28 15:06:38Z

0

If you are using Linux app service plan, this is impossible. Hybrid connectins just supported by Windows type app services. You can use Vnets on Linux app service plans.

answered Feb 28, 2020 at 15:06

Osman Taskiran

3593 silver badges9 bronze badges

1 Comment

ericOnline Over a year ago

It appears that as of 6/2020 Linux apps are now supported: azure.microsoft.com/en-us/updates/…

Osman Taskiran · Accepted Answer · 2020-10-20 18:41:18Z

0

You can connect to your onpremise sql serve via virtual machine linux or windows. You can connect your virtual machine to vpn gateway enabled vnet.

answered Oct 20, 2020 at 18:41

Osman Taskiran

3593 silver badges9 bronze badges

Comments

se7vanj · Accepted Answer · 2021-07-14 20:21:15Z

0

Using VNET Integration, FunctionApp can connect to on-premise SQL / services. To begin with go with the IP of the on-premise servers (not by DNS).

It's AppsServicePlan requires to be on Standard, Premium V2's.

The subnet on the VNET must be configured appropriately to allow the RFC1918 traffic. The setup will consist of using an site2site vpn gateway if not on ExpressRoute.

answered Jul 14, 2021 at 20:21

se7vanj

1602 silver badges8 bronze badges

Comments

Swinkaran · Accepted Answer · 2019-09-12 00:16:22Z

-4

Check this Microsoft tutorial. In regards to on premises database, you just need to replace the connection string with appropriate permission.

Use Azure functions to connect to Sql database

answered Sep 12, 2019 at 0:16

Swinkaran

1,2551 gold badge12 silver badges19 bronze badges

Collectives™ on Stack Overflow

Azure Functions connect to on-premises SQL Server

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related