This short blog shows you to important elements to let you connect from Windows Azure back to on premise database.
Below is actually my journey to get the Hybrid between Azure Cloud and on-premise SQL Database working.
If you search the web by using google then you will get this link
Connect to on-premises SQL Server from a web app in Azure App Service using Hybrid Connections (https://docs.microsoft.com/en-us/azure/app-service-web/web-sites-hybrid-connection-connect-on-premises-sql-server).
When I read up to Create a Hybrid Connection and a BizTalk Service, unfortunately the New hybrid connection is not functioning.
I need to fold back to Azure classic portal following the instruction in Create and Manage Hybrid Connections (https://github.com/Azure/azure-content-nlnl/blob/master/articles/biztalk-services/integration-hybrid-connection-create-manage.md).
When I install the On-Premise Setup in my on-premise VM running Windows Server 2012 R2 without Active Directory and with Visual Studio 2015 installed. I have gotten an unsolved error “CmdletInvocationException: Could not load file or assembly ‘Newtonsoft.Json, Version=126.96.36.199, Culture=neutral, PublicKeyToken=30ad4fe6b2a6aeed’ or one of its dependencies. The system cannot find the file specified.”,
I then changed to another VM that is running Windows Server 2012 R2 with Active Directory and run Visual Studio 2013. The On-Premise Setup completed successfully.
I completed the creation of the Biztalk Service in classic portal, went back to the new Azure Portal to add the Biztalk Service.
I have then started the out of the box MVC application, changed my connection string. Download the Deployment profile from the Azure App Service. Deployed successfully to Azure App Service.