The Microsoft Jet database engine cannot open the file 'msmdrep.mdb'
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 an OLAP cube database:
Failed to build the OLAP cubes. Error: Analysis Services session failed with the following error: Failed to connect to the Analysis Services server <Servername>. Error: Cannot connect to the repository. Analysis server: <Servername> Error: The Microsoft Jet database engine cannot open the file '\\folder\MSOLAPRepository$\msmdrep.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
Possible Causes
The error can occur because the logon account for the Microsoft Office Project Server Queue service is not an OLAP user on the computer on which SQL Server Analysis Services is installed.
Solution
To resolve the problem, add the logon account for the Microsoft Office Project Server Queue service to the SQLServer2005MSOLAPUser$ group and give it full permissions to the \Program Files\Microsoft SQL Server\MSSQL.2\OLAP folder. For more information, 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.