Changing User Name in AD?

If you are changing the username of a CRM user in Active Directory, you'll notice that the username field on the User record in CRM will still show the old username. That's because the change in AD doesn't propogate to the CRM database.

You'll find that even though the username field is incorrect in CRM, the user will still be able to log in as normal- that's because authentication is handled by AD and not CRM. However, exported dynamic worksheets and pivot-tables will no longer work. They will also recieve errors when trying to view most of the standard CRM reports.

To fix the problem, simply update the DomainName field in the systemuser table in your OrganisationName_MSCRM database of the affected user. After the change, their problems should be fixed.

UPDATE systemuser SET DomainName = 'MYDOMAIN\andrew' WHERE DomainName = 'MYDOMAIN\andr3w'