Ontolica Cube – Error – Required assemblies Microsoft.AnalysisServices.dll and Microsoft..

Ontolica Cube – Search (and Preview)

During installation of Ontolica Cube database, you might get the following error while trying to connect to the database on the Manage Ontolica Cube Database page:

“Required assemblies Microsoft.AnalysisServices.dll and Microsoft.AnalysisServices.AdomdClient.dll do not exist on this server. Please install them into GAC”.

Ontolica Cube uses the mentioned dlls to connect to the Analysis Services. However, these dll files are deployed only either with the SQL Server Analysis Services installation or by installing packages from the SQL Server Feature Pack for the specific version of SQL Server used. On a Web front-end machine which does not have SQL Server installed, you need to install additional packages from the corresponding Feature Pack.

This Microsoft knowledge base article informs which packages contain which dll files:
http://support.microsoft.com/kb/909392

Here you can find an example Feature Pack download page for SQL Server 2008:
http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228de03f-3b5a-428a-923f-58a033d316e1

Please download and install the following components:
- Microsoft ADOMD.NET package
- Microsoft Analysis Management Objects package

If still having problems, install also:
- Microsoft SQL Server 2008 Analysis Services 10.0 OLE DB Provider

Installation may require to restart the machine or at least to restart the IIS server.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment