Share via

Adding Linked Server to MYSQL from Azure Managed SQL

Red Matter Architect 26 Reputation points
2021-07-11T09:14:43.82+00:00

Hi Team,

I have an Azure Managed SQL Instance created in a subscription inside a VNET. I was trying to add a Linked Server for MYSQL (hosted in a VM) using SQL Server Management studio but I always get the error "Missing drivers". I know we can add linked server for MYSQL for a standalone SQL Server hosted inside a VM but I wanted to do it for Azure Managed SQL Instance.

Appreciate your help on this issue

Azure SQL Database
0 comments
Accepted answer
  1. Alberto Morillo 34,671 Reputation points MVP Volunteer Moderator
    2021-07-11T15:02:28.913+00:00

    When creating a linked server on Azure Managed Instance, you are only able to use the SQL provider (driver) to connect to Azure SQL Database, SQL Server, Azure Synapse, SQL serverless or Azure SQL Managed Instance. This is explained here and here.

    You cannot install other providers on Azure Managed Instance. It is a limitation.

    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Red Matter Architect 26 Reputation points
    2021-07-11T15:18:01.507+00:00

    thanks for the update

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.