I have developed the Azure AS model in Visual studio 2019 and its processing fine from VS. However, when i am trying to deploy to Azure AS server its throwing an error:
No mapping between account names and security IDs was done

I have developed the Azure AS model in Visual studio 2019 and its processing fine from VS. However, when i am trying to deploy to Azure AS server its throwing an error:
No mapping between account names and security IDs was done

Hello @RRNetha,
This normally happens when one of the existing accounts in the security group has a problem with it, e.g. it no longer exists.
From the SQL management studio, connect to Analysis services and go to Roles, under the roles, the user that has been removed from active directory will appear in question marks "?" , remove the user and reprocess the model.
Hope this helps. Do let us know if you any further queries.
Please don’t forget to Accept Answer and Up-Vote wherever the information provided helps you, this can be beneficial to other community members.
@PRADEEPCHEEKATLA-MSFT , I don't see any Roles created yet so we can rule out issue with Rules. Do we need whitelist the IP address of Synapse SQL Pool at firewall level in Analysis server and vice versa?
thanks
@PRADEEPCHEEKATLA-MSFT - I think i understand the issue. I have set the impersonation mode as "Use the Service Account" and Azure Analysis service does not have any system defined Managed Identity. What are the other ways to process the cube from SSMS.
Thanks
Hello @RRNetha,
We are reaching out to the internal team to get more help on this, I will update you once we hear back from them.
Meanwhile, you can go through the Azure Analysis Services - Authentication and user permissions.
Hi @PRADEEPCHEEKATLA-MSFT - Thanks for following up this up. I have used SQL authentication at SSMS level instead of "Active Directory Integrated Authentication" since SSMS is not understanding that. This could have been documented well in microsoft documentation. I nearly spend 2 days to find this out :(
Appreciate your help!
5 people are following this question.
Unable to create analysis services resource
Changing analysis service tier from S1 to B1
In Analysis Services, turning the AlwaysUseGateway property True/False
ADOMD. Net Product Version 18.7.0.1 trows exception when extracting data from Azure Analysis Service
Unable to upgrade tabular level to compatibility level to 1500