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 :
Microsoft Dynamics GP (Archived)

Need Help with an Orphaned User Account

(0) ShareShare
ReportReport
Posted on by 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

I have the same question (0)
  • Tim Wilson Profile Picture
    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
    185 on at
    Re: Re: Need Help with an Orphaned User Account

    Thanks Again.  I'll try this today.

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

    Thank you Victoria

  • zelleay Profile Picture
    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
    22,768 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

Responsible AI policies

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

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 2

#1
babubaskaran@outlook.com Profile Picture

babubaskaran@outloo... 2

#1
Yng Lih Profile Picture

Yng Lih 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans