Error adding user to SSAS cube role

No mapping between account names and security IDs was done.

When trying to add a new group to role membership of an SSAS cube, I was presented with this error. The new group definitely existed and was spelt correctly. The problem was one of the existing users in the role that didn’t exist anymore.

It seems when adding new members to the role, SQL Server validates all the existing users as well. It was simply a matter of searching Active Directory for all the users and groups and seeing which one didn’t exist.

After removing that one I was able to add the new group with no problems.

 

2 thoughts on “Error adding user to SSAS cube role

  1. I’d like to verbalize hello to the forum – I at most ascribe to the uncommon fish forum so paralytic and things being what they are I’ll deem to be a burden of something. Largest Regards

    1. Most amusing spam ever. No link to ugg boots or fake North Face jackets or links at all! Have I unwittingly approved something more insidious?

Leave a Reply

Your email address will not be published. Required fields are marked *