After username change in AD, old username is displayed in SQL Reporting Services

Question

Good day,

I have a developer whose username was changed in Active Directory; however in SQL Reporting Services, the old username is displayed for new reports he creates since the username change.

The server is running Windows 2008 R2 Standard with SQL Server 2012 Standard.  The domain functional level is 2012.

My guess is the server running Reporting Services has cached the old username associated with the SID of the account, but I don't know how to "flush" that information.

Any suggestions?

Thanks in advance!

Answer 1

Hi Taxslayer,

Reporting Services stored users with users’ SID. After we type a username in the username textbox, the Reporting Services will use the method “LookupAccountName” in Windows API to get the user’s SID.  Please get the type the new username and old username to get the SID follow the steps below.

1. Please download the application from the following address, and then run the application.
   http://cid-3c7e963ff6ccd974.skydrive.live.com/self.aspx/.Public/GetSid.exe
2. Type the user name in the username textbox, and then click “Find”.

This issue may be cause by SQL Active Directory User ID SID Mismapings, for more information about it, please see:
http://www.allenkinsel.com/archive/2010/02/sql-active-directory-user-id-sid-mismapings/

Hope this helps.

Regards,
Charlie Liao

If you have any feedback on our support, please click here.

---

Charlie Liao
TechNet Community Support