Known Issues
Important to have the right version of the OLEDB for OLAP provider (PTS Pivot Table Services)
It is important to have the right version of the provider on the portal server and on each client. The version must also match the version used on the OLAP server and the client.
How to obtain latest SQL service pack
These Microsoft support articles lists available service packs and how to obtain them.
Versions
To check which version that is installed locate the following file(s) located in the folder C:\Program Files\Common Files\System\Ole DB, for AS 2008 folder C:\Program Files\Microsoft Analysis Services\AS OLEDB\10:
Msolap110.dll (Analysis Services 2012)
- 11.0.2100.0, Analysis Services 11.0 Release
- 11.0.3000.0, Analysis Services 11.0 SP1
Msolap100.dll (Analysis Services 2008)
- 10.0.1600.0, Analysis Services 10.0 Release
- 10.0.2531.0, Analysis Services 10.0 SP1
- 10.0.4000.0, Analysis Services 10.0 SP2
- 10.0.5500.0, Analysis Services 10.0 SP3
- 10.50.1600.1, Analysis Services 10.0 R2
- 10.50.2500.0, Analysis Services 10.0 R2 SP1
- 10.50.4000.0, Analysis Services 10.0 R2 SP2
Msolap90.dll (Analysis Services 2005)
- 9.0.1399.0, Analysis Services 9.0 Release
- 9.0.2047.0, Analysis Services 9.0 SP1
- 9.0.3042.0, Analysis Services 9.0 SP2
- 9.0.4035.0, Analysis Services 9.0 SP3
- 9.0.5000.0, Analysis Services 9.0 SP4
Msolap80.dll (Analysis Services 2000)
- 8.0.1.94, Analysis Services 8.0 Release
- 8.0.3.23, Office XP
- 8.0.384.0, Analysis Services 8.0 SP1
- 8.0.534.0, Analysis Services 8.0 SP2
- 8.0.760.0, Analysis Services 8.0 SP3
- 8.0.2039.0, Analysis Services 8.0 SP4
Msolap.dll (OLAP Services 7.0)
- 7.0.1073, Original SQL Server 7.0 OLAP Services release
- 7.0.1295, OLAP Services SP1
- 7.0.1458, OLAP Services SP2
- 7.0.1508, OLAP Services SP3
If more than one version of OLEDB for OLAP provider (PTS) installed
If you have more then one OLEDB for OLAP provider installed you may need to specify the version of the provider in the connection string, then use:
- MSOLAP.1 for MSAS 7.0
- MSOLAP.2 for MSAS 2000
- MSOLAP.3 for MSAS 2005
- MSOLAP.4 for MSAS 2008
- MSOLAP.5 for MSAS 2012
MSOLAP is a version independent registry key that should point to the latest version of OLE DB for OLAP. If you for example have both OLE DB for OLAP for Microsoft Analysis Services 2000 and OLE DB for OLAP for SQL Analysis Services 7.0 installed make sure that the MSOLAP registry key points to the SQL Analysis Services 2000 version.
The value for the MSOLAP registry key should be: {a07ccd0c-8148-11d0-87bb-00c04fc33942}. Not {a07ccd00-8148-11d0-87bb-00c04fc33942} which is for SQL Analysis Server 7.0. Be careful - It only differs on one digit between the versions.