question

RedMatterArchitect-4825 avatar image
1 Vote"
RedMatterArchitect-4825 asked AlbertoMorillo commented

Adding Linked Server to MYSQL from Azure Managed SQL

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered AlbertoMorillo edited

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.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

RedMatterArchitect-4825 avatar image
0 Votes"
RedMatterArchitect-4825 answered AlbertoMorillo commented

thanks for the update

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

You are very welcome! Thank you for visiting Microsoft QA forums!

0 Votes 0 ·