Try to create a new user - Error stating that a user with domain login already exists

(0) Share

Report

Posted on by Community Member

Hello,

I have to create a new user and I am getting the following error message:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: The specified Active Directory user already exists as a CRM user.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ErrorCode>-2147214036</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>The specified Active Directory user already exists as a CRM user.</Message>
<Timestamp>2017-11-30T19:31:44.0199116Z</Timestamp>
<InnerFault i:nil="true" />
<TraceText i:nil="true" />
</OrganizationServiceFault>

The problem is that the user does NOT exist in the system.
What I found out is that someone tried to change the logon for an existing user (which is no longer with the company) with the logon of the new user.
The user could logon to the system but it shows the name of the old user.
Now they want me to create a new user but I cannot because I get the message above. The old user has been changed back to his original logon.

I already looked into all SYSTEMUSER tables of the MSCRM_CONFIG and the ORG_Database. I cannot find anything related to the new user but still I get the error.

Anybody any idea or suggestion?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

I would suggest to use SQL Profiler to understand the trace. I'm pretty sure it's related to your MSCRM_Config DB. Just try to run SQL Profiler during creation of user until you get that error and analyze results - that will give you an answer.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

Hello,

I solved my problem with the help of this post:

blogs.msdn.microsoft.com/.../authentication-when-you-are-adding-a-new-user-to-crm-or-a-user-to-a-new-organization-in-crm

I deleted the user entries in table [MSCRM_CONFIG].[SystemUserAuthentication] and set the field 'IsDeleted' in table [MSCRM_CONFIG].[SystemUserOrganizations] to '1' for the "old" user.

Once this was done I could create my new user.

Thanks

Was this reply helpful? Yes No
Suggested answer

Syed Ibrahim 6,257 on at

Like (0)

Report

with my past experience we faced similar issue. We were not able to create the new user because in AD we had another user of same name or email address(inactice user). if you are trying to create new user with the same email you may get such error. Rather if you still want to use the same user name then go ahead and try to create user with different email id. Because in CRM there is no provision to delete the user completely (Only can deactivate).

hope this helps

Was this reply helpful? Yes No