Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scottichrosaviakosmos
Yak Posting Veteran
66 Posts |
 Posted - 2012-04-26 : 14:45:29
|
| A new thing i came to know about SSAS. I have an Analytical server database with many cubes.I have made some changes to the roles and now i want to deploy it to some other server which i don't have access.I made some role changes in SSMS and then i imported it in BIDS and built. Then I extracted script from deployment wizard.Now when i am running the script on other servers the roles are not deploying properly.Example. I set role country with allowing users of US to access US states. its fine for the server from where i was extrating script and working fine but when deploying it to other servers its showing other countries also in accessrights. I thought scripts are best option but now what.?Is that some id or what i don't know. Any comments.?scoo |
|
|
|
|
|
deployment script not working with new roles