When i try to deploy my project or the cube within it i first i get a message 'The server content appears out of date'
then in the error list it tells me 'user does not have permission to create object on [servername] or object does not exist.
Why is this?
Should i create a database first in sql managment studio with a particular name, the name of the project for example. I have tried different impersonation modes...
What login account does analysis services run under when it tries to connect to deploy?
Does it try to create an analysis services database?
Any advise or pointers would be greatly appreciated. Thanks alot.
Jules
The project deployment in BI Dev Studio is happening under your account. You need to have administrative rights ( in many cases ) to deploy your project.
By default all local machine Administrators are also administrators of Analysis Server.
Check check your project properties to see which server you deploy your project to.
You can also open SQL Management studio to see the state your database after your deployed it to Analysis Server.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment