No longer have permission to access Management Reporter after you make changes to your domain

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

Symptoms

After making changes to your domain, users are not able to access Management Reporter.

Cause

Windows SID has changed for the user and is no longer valid.

Resolution

Update Windows SID for a user that has the Administrator role in Management Reporter.

  1. Sign in to the SQL server as one of the users that has the Administrator role in Management Reporter.
  2. Select Start >Run and enter CMD.
    1. At the Dos command type: Whoami /user
    2. In the DOS window, right-click, select Select All, and then press Enter.
    3. Paste the information into Notepad.
    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