Management SSAS Deployment Wizard Retaining Permissions
| SSAS Deployment Wizard Retaining Permissions |
| Written by Dan English |
| Monday, 21 July 2008 01:20 |
|
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... |
Latest Author Articles
- SSAS Deployment Wizard Retaining Permissions
- Video: Did you know? SQL Server 2008 includes Dimension Designer Enhancements (SSAS)
- PerformancePoint Server - Monitoring & Analytics Tech Night
- SSAS MDX Round = Banker's Rounding
- Using Reporting Services (SSRS) with SSAS data
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
