sql server data warehouse: 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.

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.

[quoted text, click to view]