How To Connect To Managed Instance from Machine Learning Studio

Question

We have migrated 4 on-premise DBs to Azure in an Azure Managed Instance.

We are trying to connect to these DBs from Azure Machine Learning Studio.

Some googling and a 2 year old post suggests ML does not support Managed Instances, only SQL Databases. Our testing kinda confirmed that :-(

Is it correct that ML can only connect to a SQL Databases and not a MI?

We are using MI so that we can use Azure Managed Instance Link once we have site to site vpn configured.

Thanks,

Ross

Answer 1

@RossW Yes, Azure Machine Learning studio currently does not support connections to Azure Managed Instances. It only supports connections to Azure SQL Databases. You can use the SQL Database as a data source for your machine learning models in Azure Machine Learning studio.

To connect to an Azure SQL Database from Azure Machine Learning studio, you need to follow these steps:

1. Create an Azure SQL Database and make sure that it is accessible from your Azure Machine Learning workspace.
2. In Azure Machine Learning studio, go to the Data tab and click on the +New button.
3. Select the SQL Database option and provide the necessary details, such as the server name, database name, and authentication method.
4. Click on the Connect button to establish a connection to the Azure SQL Database.
5. Once the connection is established, you can use the SQL Database as a data source for your machine learning models in Azure Machine Learning studio.