Sql-server – The following system error occurred: No mapping between account names and security IDs was done

active-directorycubesql serverssasvisual studio

While trying to Process a cube i go this error

"Error 133 The following system error occurred: No mapping between account names and security IDs was done. 0 0"

i know its some user which is available in the roles have been removed from active directory.

the annoying part in this is the error doesn't indicate which user has been removed from active directory, our SQL is setup as windows authentication.

and i have to go and check one by one.

is there a way to identify the user, so i remove it and continue with the processing

Best Answer

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 him and reprocess the cube

Related Solutions

Sql-server – Will SYSTEM_USER return the unique user id for users authenticated by Active Directory

A call to system_user will return the AD user's name in your case. For instance, if you have a user set up as YourDomain\YourUser1:

select system_user

-- this returns "YourDomain\YourUser1"

If YourDomain\YourUser1 is part of a AD group (i.e. YourDomain\YourGroup1), then it would still have the same output as above (returning "YourDomain\YourUser1").

Sql-server – SQL Server account delegation setup

Based on the information you provided in the SQL script, the NT account which the SQL Server service is running under doesn't have access to the folder which the file is sitting in. You'll need to see which account the SQL Service is running under, then grant that account rights to the folder.

Best Answer

Related Solutions

Sql-server – Will SYSTEM_USER return the unique user id for users authenticated by Active Directory

Sql-server – SQL Server account delegation setup

Related Question