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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

A user with this name already exists. Select a different name (adding MR user)

(0) ShareShare
ReportReport
Posted on by 110

My client is receiving this error when attempting to add a new user to Management Reporter.  I have queried the SecurityPrincipal and SecurityUser tables and I do not  see a user with the Name or UserName.  Has anyone run across this message before.   We have close to 50 MR users setup and did not have any problems.

*This post is locked for comments

I have the same question (0)
  • Mahmoud Saadi Profile Picture
    32,738 on at

    I have actually never came across this issue, although, I believe the previous post sheds a light on an important point related to the "display name", have you seen this Management Reporter - A User with this name already exists ?

  • Cheryl Aceto Profile Picture
    110 on at

    I did see that post and checked for like names.   I also verified there was not a blank display name.  Perhaps the ID is the same; however, I'm not sure how to compare the ID value against the AD users.

  • Cheryl Aceto Profile Picture
    110 on at

    Mystery is solved.  There is a table called SecurityUser in the ManagementReporter database.  There is a column named WindowsSecurityIdentifier.  This column represents the SID number in Active Directory.  When I queried this table based on the SID number in Active Directory I found that the SID for the user I was trying to add to MR was associated to a different user in MR.  I hope this helps the next person who runs across this problem.  The IT firms merely changes the id and name of the active directory record when someone leaves and is replaced.  We have changed our process for managing users in MR based on this information.

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#2
mtabor Profile Picture

mtabor 1

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans