Sign Up for Training |
Jet Global Company Site
Submit a Request
Give Feedback

Error: No mapping between account names and security IDs was done


When attempting to deploy rights from the OLAP Server User Rights screen, the following error message may appear:

"The following system error occurred: No mapping between account names and security IDs was done. .  Do you want to try again?"


There is a user (or users) that have either been removed from the Windows Active Directory or have had names changed since the last successful OLAP Security Rights deployment.


To resolve this issue, you will need to identify which user it is that is causing the disconnect.  The easiest way to do this is to go into SQL Server Management Studio, connect to Analysis Services, and then review the properties for each role within your OLAP server.  You should see one that has either a blank row, no entries at all, or a name that doesn't conform to your Active Directory environment.  Make a mental note which Role entry this is (i.e. 'DSV Admin').  Now proceed into the OLAP Server User Rights screen once more, locate this role and either select 'Remove Role' (if only one user) or 'Edit Role' (if more than one user).  If you choose 'Edit Role', locate the Active Directory entry in question from the ensuing list and remove it.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request