I have a developer that receives the error "Cannot attach to the OLAP Data
directory" when he tries to archive a database. He is a member of OLAP
Administrators and can do other activities with the database.

I am able to run the archive without any problems.

Any help would be appreciated.

Is there an ACL restricting the data folder?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"DML" <DML (AT) discussions (DOT) microsoft.com> wrote

The user was added to OLAP Administrators and that group was given full
rights to the entire 'DATA' directory and given modify rights to the 'BIN'
directory for Microsoft Analysis Server.

He can do other activities with the OLAP.

I can run the Archive without any error.




"Dave Wickert [MSFT]" wrote:

Beyond ACLs and file permissions -- which you say you have done -- there
isn't much more to go on. As a brute force techinque, which I don't
recommend lightly, what happens if they are added to the machine
administrators group?
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"DML" <DML (AT) discussions (DOT) microsoft.com> wrote