User283571144 posted
Hi acmedeepak,
I started working on Azure recently and have a requirement to host a website into Azure. Now, I need to connect to a local SQL server database from this azure hosted website. Can this be
done? If Yes, Please let me know how? Thanks in advance.
According to your description, I suggest you could consider using
Azure App Service Hybrid Connections.
Hybrid Connections can connect Azure App Service Web Apps to on-premises resources that use a static TCP port. Supported resources include Microsoft SQL Server, MySQL, HTTP Web APIs, Mobile Services, and most custom Web Services.
More details, you could refer to below article:
https://github.com/Huachao/azure-content/blob/master/articles/app-service-web/web-sites-hybrid-connection-connect-on-premises-sql-server.md
Best Regards,
Brando
