question

DanThiru-4854 avatar image
0 Votes"
DanThiru-4854 asked ·

Linked server from Azure Managed instance to Azure Analysis services

In the Azure document, it has mentioned the below info about creating Linked Server in Azure Managed Instance.

Linked server does not support the below targets.
files,
Analysis Services, and other RDBMS.

What do they mean by analysis services , are they referring to Azure Analysis services or Sql server Analysis services(On-premises).

We have a current setup where our on-premises sql server has linked server connected to SSAS. We are planning to migrate the sql server to Azure managed instance and also create azure analysis services. Can we create linked server from Azure managed instance to Azure analysis services, if yes please provide some documentations.

Thanks

azure-sql-database
10 |1000 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.

1 Answer

Mike-Ubezzi-MSFT avatar image
1 Vote"
Mike-Ubezzi-MSFT answered ·

Hi @DanThiru-4854.

The Linked Server provider will only work to link another SQL Server and will not work in the case of Azure Analysis Server. Please see the following UserVoice entry (Linked Server to non SQL Sources) to up vote and comment upon this desired functionality.

You only are able to use the SQL provider to connect to Azure SQL Database, SQL Server or Azure SQL Managed Instance.

Please see the Azure Database Support Blog: Lesson Learned #63: It is possible to create Linked Server in Azure SQL Managed Instance?

Regards,
Mike

· Share
10 |1000 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.