This recipe requires us to create the Azure Functions (with the V1 runtime) and the SQL Database in the same resource group. If you haven't created these, create them and come back to this recipe to continue. Here are the steps that we will be performing in this recipe:
- Creating a function app using Visual Studio 2017 with V1 runtime
- Creating a Logical SQL Server and a SQL database
- Enabling Managed Service Identity from the portal
- Retrieving Managed Service Identity information using the Azure CLI
- Allowing SQL Server access to the new Managed Service Identity
- Executing the HTTP trigger and testing