SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Analysis Services 2005 Deployment Wizard - Built by Design (Bug)

We use the Analysis Services Deployment Wizard when moving our cubes from Dev to QA and then QA to Prod.  Up until this point, we have been in "Beta" meaning that we have a few developers that have access plus a few SME's (Subject Matter Experts).  So every once in a while we would get a call from one of the SME's saying that they no longer have access.  We would look at the Analysis Services Role in which we are granting them access via and all permissions would be cleared and set back to none. 

This issue we would only see once every other month and was tough troubleshooting since we didn't have that many SME's hitting the system on a frequent basis and all of the developers had admin access by default.  As we got closer to "Go Live" we were making much more frequent promotions and the SME access was much more frequent.  This allowed us to better troubleshoot the access permissions and we ended up finding that one of the options on the Deployment Wizard doesn't really do what we thought it should do.

The deployment option we would use every once in a while (again leading to tougher troubleshooting) was the "Retain roles and members".  Per my understanding, this option should not deploy nor affect the current databases roles or membership.  However, this apparently is not the case as per this support article: http://support.microsoft.com/default.aspx/kb/933836.

Marc Beacom  ...

Marc Beacom

Marc Beacom – MCTS (BI, Dev), Principal Architect and Owner at DawaBI, has over 15 years of technical and business experience. DawaBI focuses on Making Data-Driven Decisions Possible by delivering user friendly and scalable data warehouse and business intelligence solutions. Marc is an active volunteer within the community and currently is co-organizer of the Colorado GiveCamp, served a year as a PASS Regional Mentor and served five years on the leadership board for the Denver and Colorado Springs SQL Server User Groups.


No comments.

Leave a Comment

Please register or log in to leave a comment.