SSAS Deployment Error: No Mapping between Account Names and Security IDs was Done.

Posted by on Jun 3, 2013 in SSAS | No Comments

This is a common error in SQL Server Analysis Services (SSAS). when you deploy the project to SSAS Server, you might face this error.


There are some user/group membership added to roles in SSAS project, that is not matching with Active Directory user/groups.

for example you might find some membership entries with GUID listed in Role Editor, under Membership tab.

or you might see some user/group under membership tab, that are no longer exists in Active Directory.


Solution is to remove any membership entries that does not match with active directory entries, and the deploy.

if you don’t know which one is not match, start from those that has GUID instead of user/group name under membership tab. if it still has issue, then one or more of existing user/group listed under that group may be removed from active directory entries. so simply ask Network Administrator to check which user/group of that list are no longer exists. remove that and deploy again.

Hope it helps you to save time on this issue. 

Reza Rad
Reza Rad is an Author, Trainer, Speaker and DW/BI Consultant. He has a BSc in Computer engineering; he has more than 15 years’ experience in databases, programming and development mostly on Microsoft technologies. He is a Microsoft MVP in Data Platform for seven continues years (from 2011 till now) for his dedication in Microsoft BI. He is author of some SQL Server and BI books, and also Power BI online book; from Rookie to Rock Star.

Leave a Reply

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