This article provides a resolution for the permission issue that occurs after you make changes to your domain.
Applies to: Microsoft Management Reporter 2012, Microsoft Dynamics GP, Microsoft Dynamics AX 2009, Microsoft Dynamics SL 2015, Microsoft Dynamics SL 2011
Original KB number: 3163587
After making changes to your domain, users are not able to access Management Reporter.
Windows SID has changed for the user and is no longer valid.
Update Windows SID for a user that has the Administrator role in Management Reporter.
SELECT A.UserName, B.Name, CASE A.ROLETYPE WHEN 2 THEN 'VIEWER' WHEN 3 THEN 'GENERATOR' WHEN 4 THEN 'DESIGNER' WHEN 5 THEN 'ADMINISTRATOR' END AS SecurityRole, A.WindowsSecurityIdentifier, A.UserID, CASE A. AccountDisabled When 0 Then 'Enabled' When 1 Then 'Disabled' End AS AccountStatus FROM Reporting.SecurityUser A JOIN Reporting.SecurityPrincipal B ON A.USERID = B.ID ORDER BY A.UserName
SELECT A.UserName, B.Name, CASE A.ROLETYPE WHEN 2 THEN 'VIEWER' WHEN 3 THEN 'GENERATOR' WHEN 4 THEN 'DESIGNER' WHEN 5 THEN 'ADMINISTRATOR' END AS SecurityRole, A.WindowsSecurityIdentifier, A.UserID, CASE A. AccountDisabled When 0 Then 'Enabled' When 1 Then 'Disabled' End AS AccountStatus FROM SECURITYUSER A JOIN SECURITYPRINCIPAL B ON A.USERID = B.ID ORDER BY A.UserName
UPDATE Reporting.SecurityUser SET WindowsSecurityIdentifier = '' WHERE UserID = ''
UPDATE SecurityUser SET WindowsSecurityIdentifier = '' WHERE UserID = ''
UPDATE Reporting.SecurityPrincipal SET Name = '' WHERE
UPDATE SecurityPrincipal SET Name = '' WHERE