SSAS Deployment loses roles

Hi,

Whenever I update my SSAS Cube and redeploy my changes, I lose the roles that are setup in the database.  I need a role defined for sqlbiagent so I can automate the Process Cube task witin SSIS.

I am using SQL Server 2008.

Can I redeploy the cube without having to rebuild the database or am I stuck setting up the roles over and over again?

Thanks,
Todd
Todd_FieldsAsked:
Who is Participating?
 
Todd_FieldsConnect With a Mentor Author Commented:
This was posted a while back with zero responses.  For anyone else who hits this, here's what's up with SSAS SQL 2008.

You need to run the deployment wizard pictured below.  Now that's not that hard ...  There is a retain roles option in the wizard.  

I did export my deployment to a script so I don't have to run the wizard every time, so I'll be working through that next.  I'm sure there will be an Expert exchange post on that.

Enjoy.
SSAS-Deploy.jpg
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.