Azure SQL Managed Instance - Error while connecting to Analysis Service - "The OLE DB provider "MSOLAP" has not been registered"

Question

Hi all,
we are modifying our application to use a Azure SQL Managed Instance, after changing a few definitions in the installation process and some SQL code we have the database code running.

The only exception is the access to a Analysis Service running in windows VM in the Azure.
We have a linked server that runs without a problem in SQL Server (local Windows or inside a VM in Azure), but we try to connect from the Azure SQL Managed Instance we get this error:

I'm unable to find documentation on how we are able to reach the AS server from an Azure SQL Managed Instance.
Do you have any hints or solutions on how to make this connection?

Thanks for your help,
Luís Pinho

Answer 1

Hi LuisPinho

Linked servers in managed instances support a limited number of targets:

· Supported targets are Managed Instances, Single Databases, and SQL Server instances.

· Linked servers don't support distributed writable transactions (MS DTC).

· Targets that aren't supported are files, Analysis Services, and other RDBMS. Try to use native CSV import from Azure Blob

Calling the external package from one of your VMs (DTEXEC or a an agent job) with the OLEDB access driver installed would be the solution, as opposed to calling it from the MI instance.

Please find more details at Linked Servers

Hope this helps.

Thanks

Navtej S