Skip to content Skip to navigation

MSSQLTREK

My Journey with SQL Server….!

SSAS

SSAS – No mapping between account names and security IDs was done.

by sreekanth bandarlaJuly 31, 2018

In this short blog post, Let’s see a strange error which one could encounter when dealing with permissions in SQL Server Analysis Services(SSAS). So, I was working on a DEV SSAS Instance to grant admin rights for our DW team this morning and ran into something which is very interesting. Basically I was unable to add any new AD user accounts/Groups to the server administrator role. SQL Server was throwing below error at me.

The following system error occurred: No mapping between account names and security IDs was done.
(Microsoft.AnalysisServices) 

If you notice in the above screenshot, there are couple of stale AD accounts(Shown as random GUIDs). These accounts were added couple of years ago(These guys are no longer working here and they were deactivated in AD) and SSAS is basically validating all the accounts which are listed under server administrator role when I am trying to add a new valid account, not just the one which I am currently adding.

Fix:

Simple, I just removed those stale SIDs and presto!! I ran into a similar issue just few weeks ago when I was using Kerberos configuration manager where I had to remove invalid accounts(listed as Random GUIDs) from local admin group on the windows server.

So there you go, if you ever run into this issue, the fix is simple, Just get rid of those garbage accounts.

SSASNo mapping between account names and security IDs SSAS SSAS Server administrator role
1 Comment
  • Sreekanth’s Profile – About Me

Search

Recent Posts

  • How to change IP Addresses in an Always On Availability group.
  • SQL Server Read Scale Availability Groups (AKA Cluster less AGs)
  • Configure/Manage Error logs – SQL Server on Linux.
  • SQL Server 2019 – VLDB struck in “In Recovery”!
  • Uninstalling CUs/Downgrading SQL Server in Linux(RHEL7)

Top Posts & Pages

  • Upgrading Windows Failover Cluster 2012R2 to 2016
  • Installing/How to Install MySQL 5.5.16 on Windows?
  • Installing SQL Server from Command line(CMD)
  • How to Transfer(Copy) Maintenance Plans from One Server to other???....
  • Always On availability group(s) - Rolling upgrades
  • Obtaining Pipe Delimited Results from SQL Server using SSMS
  • The Network folder specified is currently mapped using a different user name and password
  • How to move AlwaysON AG Databases ?
  • Dedicated Admin Connection(DAC) from SSMS
  • SSAS - No mapping between account names and security IDs was done.

Categories

Top 30 SQL blog 2018

I am A

2014cert
mcitp-dba
MIcrosoft_SQL_Badges_DBASuperhero
MIcrosoft_SQL_Badges_ServerFan2012

Archives

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License.

Blog Visits

  • 1,199,635

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 172 other followers

Current Visitors

Follow me on Twitter

My Tweets

RSS MSSQLTREK RSS

  • How to change IP Addresses in an Always On Availability group.
  • SQL Server Read Scale Availability Groups (AKA Cluster less AGs)
  • Configure/Manage Error logs – SQL Server on Linux.
Create a free website or blog at WordPress.com.
Cancel

 
Loading Comments...
Comment
    ×