How to add Azure SQL Database External Data Source to onpremise sql server

Althaus, Benedikt 21 Reputation points
2020-11-16T16:42:41.637+00:00

Hi.

we have a Azure SQL Database running as DB for a Azure WebApp.
Now, we would like to connect a SQL Server onpremise via VPN/Expressroute with the Azure SQL Database.
This is to query from the WebApp against the Azure SQL Database but getting some data also from internals SQL server without having to change the webapp itself
(implementing second connection string and such).

We where not able to find a documentation on how to do so using vnet integration or private link.

Any idea on how to move forward here?

Migrating the onprem db to azure or syncing is not an option for now, as we are only allowed bto read a view from the onprem db and it is used elsewhere onprem also.

Azure SQL Database
Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,133 questions
Azure Private Link
Azure Private Link
An Azure service that provides private connectivity from a virtual network to Azure platform as a service, customer-owned, or Microsoft partner services.
461 questions
Azure App Service
Azure App Service
Azure App Service is a service used to create and deploy scalable, mission-critical web apps.
6,830 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ryan Hill 25,476 Reputation points Microsoft Employee
    2020-11-18T17:45:54.673+00:00

    Hi @Althaus, Benedikt ,

    When connecting your on-premises SQL database to your Azure Web App, you have the following in options:

    1. Hybrid Connection - you can install an exe on one of your on-prem servers. This exe will establish a tunnel between your app service and your database. This by far is simplest and quickest way to get going
    2. App Service VNET Integration - you can link a new VNET to your ExpressRoute and integrate your app service with that VNET. Upon doing so, your app service should use your on-prem DNS making it possible to use a traditional SQL connection string. What I'm not certain of is how you would use SSPI for security.

    Regards,
    Ryan