I am getting folloing error when I start to deploy. Either the 'DomainUserName' user does not have permission to create a new object in 'ServerName', or the object does not exist. (Microsoft.AnalysisServices) This user is in the dbcreator role ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
Hi Dinesh, Analysis services validates the windows account i.e. your windows credentials will be checked. So the windows account which you are using has to be into administrator group. Otherr alternative is to set the Analysis service to run as a specific windows account and not local system account
Well , I have a windows account but that user has a role of dbcreator. I will try your option and let you know ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
It works thanks ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/
I put my account to admin group. Also, there is a option in SSAS to add the user to Analysis service. After that it was ok. you don't have to put this user to admin group ---------------------------------------- Contributing Editor, Writer & Forums Moderator http://www.SQL-Server-Performance.Com Visit my Blog at http://dineshasanka.spaces.live.com/