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

Luís Pinho 41 Reputation points

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

Azure SQL Database
Azure Virtual Machines
Azure Virtual Machines
An Azure service that is used to provision Windows and Linux virtual machines.
7,246 questions
0 comments No comments
{count} votes

Accepted answer
  1. Navtej Singh Saini 4,221 Reputation points Microsoft Employee

    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.


    Navtej S

    0 comments No comments

0 additional answers

Sort by: Most helpful