Cannot connect to the repository; Could not find installable ISAM
This Office product will reach end of support on October 10, 2017. To stay supported, you will need to upgrade. For more information, see , Resources to help you upgrade your Office 2007 servers and clients.
Topic Last Modified: 2016-11-14
This article describes an error that can occur when you use the Microsoft Office Project Server 2007 Cube Building Service to build or update the OLAP cube database.
Problem description
An error similar to the following appears in the Build Tracking Comments log when you are building or updating the OLAP cube database, during the stage when the OLAP database is being processed:
Failed to build the OLAP cubes. Error: ProjectServerOlapCubeGenerator failed with error: Failed to connect to the Analysis Services server <AnalysisServicesServerName>. Error: Cannot connect to the repository. Analysis server: <AnalysisServicesServerName> Error: Could not find installable ISAM.
Possible causes
The error can be caused by an incorrect connection string in the Msmdsrv.ini file.
Solution
To resolve the problem, review the SQL Server Analysis Services DSO configuration settings by using SQL Server Management Studio. These settings are reflected in the Msmdsrv.ini file. For more information about editing the Analysis Services DSO configuration, see Requirements for using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service.
Download this book
This topic is included in the following downloadable book for easier reading and printing:
See the full list of available books at Downloadable content for Project Server 2007.