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:
Here you can find an example Feature Pack download page for SQL Server 2008:
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.