Users in the OLAP administrator group, except
administrator, are not able to connect to the Analysis
service after SP3 applied. The error shown as follow:

Cannot connect to the repository.
Analysis server: {server name}
Error:
Could not use ''; file already in use.

Please assist to solve the problem. Thanks.

Miranda

If the repository is still in MS Access format, right-click on the file:
C:\Program Files\Microsoft Analysis Services\Bin\msmdrep.mdb
And look at the file permissions. It may be that you've somehow deleted the
allow access for OLAP Administrators.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Miranda Kwan" <kwanps@graduate.hku.hk> wrote in message
news:09e801c3776c$e6be7280$a301280a@phx.gbl...
> Users in the OLAP administrator group, except
> administrator, are not able to connect to the Analysis
> service after SP3 applied. The error shown as follow:
>
> Cannot connect to the repository.
> Analysis server: {server name}
> Error:
> Could not use ''; file already in use.
>
> Please assist to solve the problem. Thanks.
>
> Miranda