Can Azure SQL database access on-premise SQL server tables in a query?

Sumit Yadam 1 Reputation point
2021-02-10T00:22:12.943+00:00

Hi,

We are syncing data to and from Salesforce to on-premise sql server using ADF and Azure SQL server. We are looking for a way to connect on-premise sql server via an external data source (linked server) so that we can query the on-premise data in Azure SQL stored procedures. Is there a way to do that?

Our database is behind firewall so we also need the IP address range of Azure SQL server to white list in our domain firewall. Where can I find this in azure portal?

Thank you.

Azure SQL Database
Azure Firewall
Azure Firewall
An Azure network security service that is used to protect Azure Virtual Network resources.
571 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. SUNOJ KUMAR YELURU 13,941 Reputation points MVP
    2021-02-10T00:54:30.48+00:00

    Hi @Sumit Yadam
    It is possible to create Linked Server in Azure SQL Managed Instance?
    The answer is Yes!!! and to create it you only need to follow up the instructions provided in this URL

    Linked Server alternative in Sql Azure database
    SQL Linked Server: Sending Data from On-Premises SQL Databases to Azure SQL Databases
    create linked server in azure sql database

    If the Answer is helpful, please click Accept Answer and up-vote, this can be beneficial to other community members.

    0 comments