Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

Posted on by Microsoft Employee

In NAV 2009 R2, when I click "Tools", "Security", and "Windows Logins" the SID is showing in the ID column.  This used to show actual Active Directory usernames.  Does anyone know how to change it back to the usernames over the SIDs and why this might have happened?  I see there are two columns available (ID and SID) but both show the SID.

--

Brent

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    I found that if I sign in to the Nav database as an SQL Database user on the server itself, I can then see the Windows Authentication ID usernames.  This is an inconvenient workaround for the time being.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    All the usernames are still showing in SQL Server.  Everyone is still able to sign in.  I'm not ready to recreate 50 users so they show again as an ID.  There must be another option.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    Hello,

    It means someone deleted these users from SQL Server, you can check it in SQL Server.

    I recommended you recreate all users from NAV that are showing SID.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    My ID is the only one showing correctly as "Domain\YourLoginID" already.  It's all the others that show as SIDs.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    Hello Brentman,

    If the SID is yours then update the SID with Your Name with Domain

    like:

    Domain\YourLoginID

    If not your SID then Create another login In NAV 2009 R2, when I click "Tools", "Security", and "Windows Logins"

    and assign Roles, after that delete Earlier Login that showing SID.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    Yes, logins are still present within AD.  This isn't one login showing as a SID but all of our AD logins.  The only one I'm seeing as an ID is myself.

  • Suggested answer
    Stefano Demiliani Profile Picture
    Stefano Demiliani 37,162 Most Valuable Professional on at
    RE: NAV 2009 R2 - Windows Logins Showing As SIDs Instead of Usernames

    Are the login still present on AD? Normally this happens if you've removed an account in AD.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans