web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / User cannot login due ...
Microsoft Dynamics CRM (Archived)

User cannot login due to duplicate record in CRM

(0) ShareShare
ReportReport
Posted on by Community Member

We have a user that ended up with duplicate accounts.  When I tried to change the User Name to a non-existing AD, it seems to validate and it throws an exception.  The user gets a 404 error message when trying to log into the system and current cannot access it.  We tried disabling the account and did not work. I suspect that Dynamics still looks at the disabled list and sees the other record there.  Any thoughts on how to permanently deleting this user's duplicate record?

Thanks in advance

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Aric Levin - MVP Profile Picture
    Aric Levin - MVP 30,190 Moderator on at

    You cannot delete User records from CRM. Just leave it disabled.

    You can change the domain name and email address of the user so that it doesn't point to an AD account, but that's about it.

    If you do it in SQL, it is very likely to mess up your data. sorry.

    Hope this helps.

  • Community Member Profile Picture
    Community Member on at

    Thank you Aric, that's what we ended up doing.  We created a DupUser account in AD to use when we run into these types of situations.  It is surprising that Dynamics does not have the User Name as a unique field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
SA-08121319-0 Profile Picture

SA-08121319-0 4

#1
Calum MacFarlane Profile Picture

Calum MacFarlane 4

#3
Alex Fun Wei Jie Profile Picture

Alex Fun Wei Jie 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans