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

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

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/

Azure Functions connect to on-premises SQL Server

6 Answers