Your Microsoft Office Project Server 2007 environment includes the servers shown in the following table.
You configure the Analysis Services repository by using a Microsoft Office Access MDB file.
You attempt to build an online analysis processing (OLAP) cube. You receive the following error message: Error: The Microsoft Jet database engine cannot open the file ‘C:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\DSO9\msmdrep.mdb’. It is already opened exclusively by another user, or you need permission to view its data.
You need to resolve the error.
What should you do?
A.
Add the Shared Services Provider Administrator account to the local Administrators group on Server A.
B.
Add the Shared Services Provider Administrator account to the local Administrators group on Server B.
C.
Configure the Analysis Services Service to log on as the Shared Services Provider Administrator account.
D.
Give the Shared Services Provider Administrator account full permissions for the folder that contains the msmdrep.mdb file.
E.
Delete the MDB repository file and then re-create it.