Is it possible to create a Linked Server from Azure Managed Instance to our On-Premise SQL Server?

Cooling, Steve 20 Reputation points
2023-03-06T17:35:23.16+00:00

Is it possible to create a Linked Server from Azure Managed Instance to our On-Premise SQL Server? I've successfully created a linked server from our On-Premise SQL Server to our Azure Managed Instance but have now been asked to do it the other way. Can it be done?

Azure SQL Database
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. GeethaThatipatri-MSFT 27,977 Reputation points Microsoft Employee
    2023-03-06T18:20:29.92+00:00

    Hi @Cooling, Steve Welcome to the Microsoft Q&A platform, thanks for posting the question

    Yes, it is possible to create a Linked Server from Azure Managed Instance you need to ensure that network paths are open to your on-prem server and make sure that outbound NSG rules and DNS resolution are set correctly on the MI subnet, also any firewalls are removed from on-prem server that would block traffic.

    It also depends on how you set up your on-prem network, you can test DNS resolution and ping from SQL Agent to make sure that connectivity (networking) is OK, then set up a linked server.

    this blog can be useful for testing connectivity

    Please let me know if you find any issues.

    Regards

    Geetha