2

we are migrating existing website to Microsoft Azure Websites (PaaS). The application access the on-premises MS-SQL Database for some data. we are unable to provide access through firewall (for IP, because there is no static IP for website).

Is there any other solution for it. is VPN is the solution then it possible to create VPN for "Website" to "On-Premises" MS-SQL server.

Vasistan
  • 292
  • 1
  • 10

2 Answers2

3

easiest way would be to use Hybrid Connect to connect your Azure Website to an on-premises SQL Server without messing around with networks...

have a look at this for step by step instructions on how to configure Hybrid Connect

David Makogon
  • 69,407
  • 21
  • 141
  • 189
JuneT
  • 7,840
  • 2
  • 15
  • 14
  • 1
    To be complete, I think your answer should include the fact that a hybrid connection utilizes BizTalk Services, which is a heavier-weight solution than using a virtual network. Also, I'm not sure why you think you need to "mess around" with virtual networks. They're straightforward to set up, and they provide a secure network for resources to connect. – David Makogon Feb 16 '15 at 20:42
  • from a simplicity perspective, it's easier to simply install the agent and exposed the on-premise resource than defining VNET/configuring subnet and exposing more resources on the VNET than what's required – JuneT Feb 16 '15 at 23:45
  • i know this is an old post, but this a viable option if the target is non-windows machine? – m1nkeh Mar 04 '16 at 15:47
3

You can create an Azure Virtual Network to allow you to securely access your on-prem database from Azure. http://azure.microsoft.com/en-us/services/virtual-network/

You can then connect your Azure Website to that Virtual Network to let your website connect to your database. http://azure.microsoft.com/blog/2014/09/15/azure-websites-virtual-network-integration/

Zain Rizvi
  • 23,586
  • 22
  • 91
  • 133