question

RRNetha avatar image
0 Votes"
RRNetha asked PRADEEPCHEEKATLA-MSFT commented

Azure AS Model deployment error

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

80796-capture.png


azure-analysis-services
capture.png (71.3 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PRADEEPCHEEKATLA-MSFT avatar image
1 Vote"
PRADEEPCHEEKATLA-MSFT answered PRADEEPCHEEKATLA-MSFT commented

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.

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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

0 Votes 0 ·

@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

0 Votes 0 ·

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.


0 Votes 0 ·
RRNetha avatar image RRNetha PRADEEPCHEEKATLA-MSFT ·

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!

0 Votes 0 ·
Show more comments