How to fix Analysis Services deployment error No mapping between account names and security IDs was done
User Rating: / 46
Written by Vidas Matelis   
Wednesday, 05 December 2007 17:56

Q: While deploying Analysis Services database I am getting error "The following system error occurred:  No mapping between account names and security IDs was done". How can this be fixed?

 A: Most likely you have a role defined in database that contains users or user groups not available in deployment environment. For example you have user group Domain1\UserGroup1 specified in role, but you are trying to deploy this database in environment where Domain1 is not available. To fix this error simply replace users or user groups with values that are correct in deployment domain.

Comments (30)
30 Thursday, 12 February 2015 21:58
Thanks for this answer! It worked perfectly.
29 Tuesday, 18 November 2014 07:18
Prasad Kulkarni
It worked for me...thanks...there was one user who has left the organization but his entry was there…I removed the entry and it worked very well
28 Monday, 03 November 2014 11:48
raj kamal
After replaced the user groups with values that are correct am still facing the same issue,what shall i do now,is anything else need to do to resolve this?
27 Monday, 04 November 2013 17:15
Thanks a lot.

It worked well.
26 Saturday, 11 May 2013 15:16
If you have several usernames in each role, you could try to narrow down the invalid user name by role rather than by user name.

Highlight the users in a role and copy. Click the Add button and paste the copied list in the box. Click Check Names and the invalid name should be displayed in a prompt. If there are no invalid names in the current role, all names are verified.

At least this can help you work role by role rather than one name at a time.

Hope this helps.
25 Friday, 19 April 2013 01:34
Thanks! :)
24 Thursday, 14 February 2013 18:18
Edward Johnson
This worked perfectly, thanks!
23 Monday, 10 September 2012 09:13
Answer is fine but if you have 100 of members in your roles how do you find the mismatching user ?
22 Thursday, 02 August 2012 15:06
Daniel I.
This finally solved my problem! Thanks a lot!!!
21 Friday, 06 July 2012 11:14
Thanks dude :O)
20 Wednesday, 28 March 2012 18:24
Marty Scherr
I was working on a db in a different domain. I removed all the users from the other domain and it's worked fine. thanks.
19 Wednesday, 15 February 2012 22:45
That saved a lot of time..Thanx Keep up the good work
18 Wednesday, 18 January 2012 20:05
thanks for you comments.....
17 Wednesday, 04 January 2012 21:36
This worked perfectly for me.
16 Thursday, 27 October 2011 12:44
David Laplante
This was exactly my problem! thanks a lot!
15 Friday, 14 October 2011 06:13
Aniket Patankar
Thanks !!!
14 Thursday, 02 June 2011 18:10
This helped me soooo much. Thank You.
13 Tuesday, 31 May 2011 08:21
it working :) thank
12 Wednesday, 08 December 2010 17:45
Wooo thank you!
11 Thursday, 28 October 2010 13:55
Jerry L
I removed a person who had left the company and everything works fine now. Thanks much. One of those, it used to work and now it doesn't problems.
10 Friday, 08 October 2010 03:43
sanjay dubey
got the same error while adding user in admin role on anlaysis services. but getting same error. but i found why i am getting this error and resolved that what i did is i deleted orphan users from this role after that i am able to delete new user on this. it works for me may be this is going to work for you.
best of luck.
9 Wednesday, 29 September 2010 13:26
Bespoke Paul
This issue speaks to the need to use AD groups to secure cube access instead of individual user accounts.
8 Friday, 10 September 2010 13:58
It really helped!
7 Monday, 24 May 2010 18:51
I have the same error, but the problem was some ID from people who had left the company where still there. Solution delete accounts that show like SID numbers.
6 Tuesday, 18 May 2010 06:58
Thanx, this helped me.
5 Thursday, 06 May 2010 04:38
Miguel Chavez
Thank you so much.
4 Monday, 01 March 2010 10:34
tnx so much!
3 Tuesday, 02 February 2010 01:26
Thanks a lot buddy. This helped.
2 Sunday, 19 July 2009 07:01
10q :)
1 Tuesday, 17 March 2009 09:24
Rani Rosenzweig
10q for your help.


Pyramid Analytics