Microsoft Pivot Table Services for SQL Server 2005 was not properly installed

From DataSelf Knowledge Base
Jump to navigation Jump to search

For Windows 7 32 bit, run the Setup.exe file in the following folder:

InstallationPackLocation\Desktop Install\Install

For 64 bit:

ProClarity Install Prerequisites - PTS for SQL Server 2005

With the release of Windows 7, and client workstations trending to a 64-bit operating system, inquiries about ProClarity installation prerequisites have steadily increased. ProClarity Professional includes ‘ SQLServer2005_ASOLEDB9.msi ’ which is the 32-bit version of the Analysis Services 9.0 OLE DB Provider. The installer attempts to install this as a prerequisite before installing ProClarity Professional, and on a 64-bit operating system you might see this error message:
[cid:image001.png@01CAD245.5C3D2D50]
The solution to this is to manually install the x64 version of the Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider. To manually install the provider what you’ll want to do is go to the latest Feature Pack for Microsoft SQL Server 2005<http://www.microsoft.com/downloads/details.aspx?familyid=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en> (currently December 2008) download site and download the install file, and then install ProClarity.
[cid:image002.png@01CAD245.5C3D2D50]<http://www.microsoft.com/downloads/details.aspx?FamilyID=536fd7d5-013f-49bc-9fc7-77dede4bb075&displaylang=en>