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.
Asked
Active
Viewed 3,451 times
0
-
when we talk about `providers` mainly we mean to say the `drivers`. so in your case I suspect the analysis service ole db provider/driver is missing and needs to be installed. – Abhishek Aug 26 '15 at 11:57
-
In my opinion you need [Microsoft® SQL Server® 2014 Feature Pack](https://www.microsoft.com/en-us/download/details.aspx?id=42295), Microsoft® OLEDB Provider for DB2 v5.0 for Microsoft SQL Server® 2014 `DB2OLEDB5_x86.msi and DB2OLEDB5_x64.msi` Instruction: http://go.microsoft.com/fwlink/?LinkID=241541&clcid=0x409 – Lukasz Szozda Aug 26 '15 at 11:58
-
@lad2025, yes, that's it. Thanks. – DNac Aug 26 '15 at 12:05
-
I have the same problem in SQL 2017. I installed [Microsoft® SQL Server® 2017 Feature Pack](https://www.microsoft.com/en-us/download/details.aspx?id=55992) but I still do not see IBMDASQL in the provider list. My question is [here](https://stackoverflow.com/questions/69619171/ibmdasql-is-missing-from-linked-server). – Nakres Oct 19 '21 at 13:09
1 Answers
0
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)
Community
- 1
- 1
Lukasz Szozda
- 162,964
- 23
- 234
- 275