Report Portal

SSAS Deployment Wizard Retaining Permissions

Had a great question last week at the MNPASS SQL Server User Group in regards to using the Analysis Services Deployment Wizard and I just wanted to post the follow-up.  I have read about the wizard, but actually have never used it (but you need to know about it for the MCTS test 70-445 or 70-448).  I have just always deployed my databases through BIDS and have always had the roles and permissions defined in the solution.  This provided me a great opportunity to explore the wizard.  What I needed to find out was if the issue of losing the database permissions had been fixed in 2008 (refer to this MS KB article for the current issue here – basically the permissions do not get pulled into the XMLA script using the ‘Retain roles and members. The roles and members will not be deployed.’ option).

Read more...

Tags: security

 

2007-2015 VidasSoft Systems Inc.