I need to create Linked Server to MS Analysis Services, but my server does not have this provider installed. How to install it? Can't find any article about this.
Install Microsoft® SQL Server® 2014 Feature Pack
Microsoft® Analysis Services OLE DB Provider for Microsoft SQL Server® 2014
The Analysis Services OLE DB Provider is a COM component that software developers can use to create client-side applications that browse metadata and query data stored in Microsoft SQL Server 2014 Analysis Services. This provider implements both the OLE DB specification and the specification’s extensions for online analytical processing (OLAP) and data mining.
Note: Microsoft Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0
Filename: X86 and x64 Package(SQL_AS_OLEDB.msi)