March 12, 2009 at 1:02 pm
All-
I get the following error when trying to deploy my SSAS cubes-
"Either the user does not have permission to alter the object or the object does not exist" (I omitted my user name and object name).
After googling the error, it seems that every other user that gets the error has to have certain permissions in the server role. I have already done that...I am an admin on the analysis services database and even have an sa account as well. I can try to use either of those logins in my connection to my staging database from SSAS, but I get the same error.
The part that myself and the other developer on my team found interesting was that I was able to migrate my SSIS packages to our development server (the same place I'm trying to deploy my SSAS cubes), and the packages run fine...no errors...no connection bs...just fine.
Any ideas out there?
Best Regards-
Matt
March 13, 2009 at 8:49 am
Figured out the error...thought I'd share for anyone else with the same issue.
Despite the fact that we were logged on to our development environment, Analysis Services was still trying to deploy to the local machine, but since our development accounts weren't admins on the local machines, Analysis Services wouldn't grant us access.
Just throwing the info out there in case anyone else needs it.
August 11, 2009 at 10:15 am
Hello,
I got the same error when I tried to deploy a tutorial SSAS project named Analysis services Tutorial. The error was: 'Either the user, Domain\userID does not have access to the Analysis Services Tutorial database, or the database doe not exist'. Everything I did prior to deployment succeeded. Does anyone encountered the same issue? Please share or give some suggestions?
Thanks
August 12, 2009 at 2:04 am
I received the same error installing it on a laptop and trying to use an account that was a SQL Server Admin account.
The problem seemed to be because it was on a vista machine. When I did the reinstall, at the end I had the chance to make the admin account a SQL admin user. From there I was able to give the "real" SQL account the necessary admin permissions. Problem solved, but pain in the neck at the time.
August 23, 2012 at 6:25 am
Error Message is:
user does not have permission to alter the 'TestCube' object, or the object does not exist.
Open Services, go to Analysis services--->right click on it --> Properties-->LogOn --> select This Account -->give server and your user name here. confirm it is your user, click ok.
Stop the service and again start the service. check the service Log On As in your user name.
Thant's it. save your cube in BIDS and close and reopen the cube, then deploy the cube. it will deploy and process it.
I hope this will help.
Srini
August 23, 2012 at 11:36 pm
shreenu.vasulu (8/23/2012)
Error Message is:user does not have permission to alter the 'TestCube' object, or the object does not exist.
Open Services, go to Analysis services--->right click on it --> Properties-->LogOn --> select This Account -->give server and your user name here. confirm it is your user, click ok.
Stop the service and again start the service. check the service Log On As in your user name.
Thant's it. save your cube in BIDS and close and reopen the cube, then deploy the cube. it will deploy and process it.
I hope this will help.
Srini
I sure hope they solved their problem 3 years ago 😉
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply