CODEWITHSUNDEEP
sql-serverazureazure-web-app-serviceazure-vpn
Vasistan
Vasistan

Reputation: 292

Azure website need to connect on-premises SQL

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.

Upvotes: 2

Views: 2465

Answers (2)

JuneT
JuneT

Reputation: 7860

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

Upvotes: 3

Zain Rizvi
Zain Rizvi

Reputation: 24636

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/

Upvotes: 3

Related Questions