Cannot connect to the repository; File already in use

  • Article

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

The following error appears in the Build Tracking Comments log when you are building or updating an OLAP cube database, during the stage when databases and the cube are being built:

Cannot connect to the repository. Analysis server: <AnalysisServerName> Error: Could not use ''; file already in use.

Possible causes

Any of the following things can cause this error:

  • On the computer on which SQL Server Analysis Services is installed, the OLAP Administrator group does not have security permissions set on the \Program Files\Microsoft Analysis Services\Bin folder. It must have all the permissions checked except for the Special Permission item.

  • The user on the Project Server Application Server that is connecting to the computer on which SQL Server Analysis Services is installed is not a member of the OLAP Administrator group on the SQL Server Analysis Services computer.

  • The /Program Files/Microsoft Analysis Services/bin directory is not shared as msolaprepository$.

  • The msolaprepository$ directory is not shared to the OLAP Administrators group.

  • SQL Server Analysis Services erroneously holds a lock on the .mdb file.

Solution

To resolve the problem, try the following actions:

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.