Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Need Help with an Orph...
Microsoft Dynamics GP (Archived)

Need Help with an Orphaned User Account

(0) ShareShare
ReportReport
Posted on by Tim Wilson 185

Hi,

 I'm very new to Dynamics GP, (using 10.0), so I thought I would ask this question here before going in head first with no water and screwing something up.  I had created a user account in SA mode incorrectly.  That user had never used the account and I deleted it in dynamics in the user account interface. Dynamics GP -> tools -> setup -> system -> User [delete]

 My question is, I wanted to use the same user ID to re-create the account but I keep getting a message that the user still exists in the DataBase which doesn't surprise me.  So, is there a way to purge that user id or reuse it somehow?

(my appologies if this has already been covered but I couldn't find it in the 1400 + items listed.)

 Any help would be appreciated.

*This post is locked for comments

  • Tim Wilson Profile Picture
    Tim Wilson 185 on at
    Re: Re: Re: Need Help with an Orphaned User Account

    Thanks again for the Help.  Those steps did the job and were extremely easy.

     

    -Tim

  • Tim Wilson Profile Picture
    Tim Wilson 185 on at
    Re: Re: Need Help with an Orphaned User Account

    Thanks Again.  I'll try this today.

  • Tim Wilson Profile Picture
    Tim Wilson 185 on at
    Re: Re: Need Help with an Orphaned User Account

    Thank you Victoria

  • zelleay Profile Picture
    zelleay 115 on at
    Re: Need Help with an Orphaned User Account

    Hi!

    You may want to check SQL server logins. The login/user that you have created may not have been deleted from it.

     Also, please check Security Logins for the databases (Dynamics & Company Database). If it exist under these databases, it must also be deleted.

     

  • Victoria Yudin Profile Picture
    Victoria Yudin 22,766 on at
    Re: Need Help with an Orphaned User Account

    Tim,

    You need to delete the user directly in SQL Server Studio Management (or Enterprise Manager if you're on 2000).  I would first check the Logins under Security.  If the user login is there, deleting it from there will also delete it from all the databases.  If it's not there, you will need to look at every GP database (including DYNAMICS) to check for it and delete it from any databases it's in.  Once this is done, you will be able to re-create the user in GP.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans