Azure AS Model deployment error

rajendar erabathini 616

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

1 answer

PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee

2021-03-24T07:17:35.03+00:00

Hello @rajendar erabathini ,

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.
Please sign in to rate this answer.

1 person found this answer helpful.
rajendar erabathini 616 Reputation points

2021-03-24T10:48:59.673+00:00

@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

rajendar erabathini 616 Reputation points

2021-03-24T14:11:05.38+00:00

@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

PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee

2021-03-26T06:10:28.853+00:00

Hello @rajendar erabathini ,

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.

rajendar erabathini 616 Reputation points

2021-03-26T06:32:21.097+00:00

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!

PRADEEPCHEEKATLA-MSFT 78,331 Reputation points Microsoft Employee

2021-04-06T07:52:56.007+00:00

Hello @rajendar erabathini ,

Unfortunately, I have not received much input on this from the internal team.

For a deeper investigation and immediate assistance on this issue, if you have a support plan you may file a support ticket.
Sign in to comment