Skip to content

MSSQLTREK

My Journey with SQL Server….!

  • Sreekanth’s Profile – About Me

Tag: No mapping between account names and security IDs

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

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.

Author sreekanth bandarlaPosted on July 31, 2018Categories SSASTags No mapping between account names and security IDs, SSAS, SSAS Server administrator role1 Comment on SSAS – No mapping between account names and security IDs was done.

Search

Recent Posts

  • neo4j – Basic configuration.
  • How to Install Neo4J in RHEL/CENTOS?
  • 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.

Top Posts & Pages

  • The EXECUTE permission was denied on the object 'xp_prop_oledb_provider', database 'mssqlsystemresource'
  • The server principal already exists - Msg 15025, Level 16, State 2, Line 1
  • Obtaining Pipe Delimited Results from SQL Server using SSMS
  • How to change IP Addresses in an Always On Availability group.
  • Upgrading Windows Failover Cluster 2012R2 to 2016
  • Installing SQL Server from Command line(CMD)
  • Installing/How to Install MySQL 5.5.16 on Windows?
  • How to Transfer(Copy) Maintenance Plans from One Server to other???....
  • Always On availability group(s) - Rolling upgrades
  • How to Add a New Disk/Drive to SQL Server Failover Cluster?

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,314,087

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

Join 171 other followers

Follow me on Twitter

My Tweets

RSS MSSQLTREK RSS

  • neo4j – Basic configuration.
  • How to Install Neo4J in RHEL/CENTOS?
  • How to change IP Addresses in an Always On Availability group.

Search

  • Sreekanth’s Profile – About Me
MSSQLTREK Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • MSSQLTREK
    • Join 171 other followers
    • Already have a WordPress.com account? Log in now.
    • MSSQLTREK
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...