question

Katie 1 avatar image
Katie 1 asked

Administration : Analysis Services

Hello,

What access level should a user, who is trying to deploy a SSAS cube from his local box to the network server have?

To elaborate, a user who has developed an cube,wants to deploy a cube, whose development has been done on a local machine. The user needs access to deploy the cube on to enterprise server. as a DBA what access should be granted to the user from the database side?

Is there a procedure or a best practice to follow, Please advice!

Thanks!

ssasdbaadministrationpermissionscubes
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
shahfaisal avatar image
shahfaisal answered

The user who is deploying should be member of SSAS server administrator role. By default, windows local administrators will be members of analysis services built-in administrator role, so if that user is a local admin on the box, (s)he will be implicitly granted admin rights for the entire SSAS server.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.