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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM user Appear as act...
Microsoft Dynamics CRM (Archived)

CRM user Appear as activated but he cannot log in or perform any action on this user

(0) ShareShare
ReportReport
Posted on by Community Member

Am using CRM 2013 , I have a user that appear as active but he cannot log in and when I want to change any properties of this user it gives me that the user does not exists !! I checked the sql database the user appear twice (I do not know why), am getting this message whenever I do any action on this user :

usersettings With Id = 18079858-6451-de11-8577-001c23e18ffe Does Not Exist

I appreciate your support on how I can reset or activate this user knowing that there are records related to this user.

More over I have done an upgrade from CRM 2011 to CRM 2013 and every thing is running fine except for this user.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at
    RE: CRM user Appear as activated but he cannot log in or perform any action on this user

    It's possible the user has multiple AD accounts, or you have 2 AD users with the same name?  What's most likely happened is that the user has a GUID in AD that gets assigned to the systemuser record, and that ActiveDirectoryGuid has changed in CRM so it can't find the user in AD to authenticate them.

    In either case, this is NOT an easy problem to fix.  There are no 'supported' methods that I know of to fix this.  The official advice I can give you is to contact Microsoft support and ask them to help you.

    ***** The following is an UNSUPPORTED method, so do multiple backups of your data and be prepared to quickly restore the affected rows if needed.  If you are not a SQL DBA or do not have extensive experience with SQL, find someone who is before you attempt this.  No warranties are expressed or implied, so don't blame me if you mess up your CRM. ****

    The unsupported method, is to find out the correct GUID and do a SQL update of the ActiveDirectoryGuid field on the systemuser record.  

    To find out the correct GUID, you may have to setup a Dev/Test server and go through the process of backing up and restoring the CRM instance.  During this process, you have to Import the database in the CRM Deployment manager, which makes CRM go back to AD and refresh the ActiveDirectoryGuid field.  

    Once it's restored, query the systemuser record for that user and see what the ActiveDirectoryGuid field is set to.  Be sure and have the affected user try to login to CRM on your Dev/Test server and make sure that works before you go and update your production instance.  Compare that value to the one in production.  If they are different, then you will need to update the production value to whatever is set in Dev/Test.

    Again, this is highly unsupported stuff, so use this advice at your own risk.

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    RE: CRM user Appear as activated but he cannot log in or perform any action on this user

    Thank you Chris for your input , Actually after we tried all options (the GIUD of active directory was the same) what we found is that the AuthenticationID was not correct so we replaced it with the correct ID and it worked fine but it was a tough things to detect.

    Thanks

  • ShahXu Profile Picture
    ShahXu 1,515 on at
    RE: CRM user Appear as activated but he cannot log in or perform any action on this user

    Can you guide me how to check that ?

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#2
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans