I am encountering a deployment failure to Analysis Server 2005. I am
deploying an Analysis Services 2005 project (project mode / not online) to a
remote Analysis Server (2005 / sp1) where my windows account is set up in the
OLAP Administrator local group and my windows account is added to a database
role with Full control (administrator) and it fails with the error message
saying that I do not have permission to the object. The database was
created empty by the local admin. Sometimes when I try deploying from
BIDS, it flat out deletes the Analysis Services database and fails the
deployment. Any suggestions?

Apparently there is an issue with deploying an Analysis Services project to a
remote analysis server when you are not local admin on the remote server.
You may have admin permissions to the database, but the first thing that is
done in the deploy is that the database is dropped before the new project is
deployed. The permissions you had went with the database that was dropped.
Opps! One option that will work is to manage the Analysis Services
database in an online mode.



"vnapoli" wrote: