SQL Server Performance Forum – Threads Archive

Error user does not have permission

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/

---

Hi Dinesh,
can you please share which option worked for you?

---

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/

---

]]>