问题描述
我需要创建到MS Analysis Services的链接服务器，但是我的服务器未安装此提供程序.如何安装?找不到有关此的任何文章.
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.
推荐答案
安装 Microsoft®SQLServer®2014功能包
Install Microsoft® SQL Server® 2014 Feature Pack
Analysis Services OLE DB提供程序是一个COM组件，软件开发人员可以使用它来创建客户端应用程序，以浏览元数据并查询存储在Microsoft SQL Server 2014 Analysis Services中的数据.该提供商同时实现OLE DB规范以及该规范的在线分析处理(OLAP)和数据挖掘扩展.
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.
注意:Microsoft Analysis Services OLE DB提供程序需要Microsoft Core XML Services(MSXML)6.0
Note: Microsoft Analysis Services OLE DB Provider requires Microsoft Core XML Services (MSXML) 6.0
文件名:X86和x64程序包(SQL_AS_OLEDB.msi)
这篇关于SQL Server 2014上缺少链接的服务器提供程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！