Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Locked Out! - Maximum Number of Users Logged In

(0) ShareShare
ReportReport
Posted on by

HELP!  My Great Plains locked up this morning while I was doing something, and I had to get out of the program using Task Manager.  Now I can't get back in.  When I try to log in, it gives me the error message "The maximum number of users are logged into the system."  The only option is to click "OK".  When I do that, it dumps me completely out of the program.  How can I get back in?

*This post is locked for comments

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Locked Out! - Maximum Number of Users Logged In

    Welcome to the club, Annie. We have all had to do this at one time or another.

  • RE: Locked Out! - Maximum Number of Users Logged In

    Whew!!!  I'm in!  Thank you so much.  I really hesitated to hit that "execute" button, because I wasn't sure I was doing it right.  But it worked perfectly.

    Thanks again!

  • Verified answer
    Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Locked Out! - Maximum Number of Users Logged In

    You need to get someplace where you can run a query. If you have a really old version of SQL it will be called Query Analyzer or the new version SQL Management Studio. You need to type this in the query are

    DELETE DYNAMICS..ACTIVITY and then click Execute or F5.

    You can also accomplish the same thing by logging into GP as someone else and going to Tools->Utilities->System->User Activity and delete your session from there.

  • RE: Locked Out! - Maximum Number of Users Logged In

    I did some googling and found my way into my Sequel Server Management Studio.  It's an older version.  So when you say "run this script", would that be a new query?  I'm very hesitant to work with this, as I know zero about what I'm doing.

  • RE: Locked Out! - Maximum Number of Users Logged In

    Great Plains 10.0

    I'm the only one on Great Plains, so there would be nobody else in the system.

    Can you help me understand what SSMS is and how to get to it?  Is it Sequel Server?  I know that I've got Sequel Server, but I've never really dealt with it.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,788 Moderator on at
    RE: Locked Out! - Maximum Number of Users Logged In

    What version of GP? You can go into SSMS and run this script  DELETE DYNAMICS..ACTIVITY.

    Make sure no one is I GP when you do this.

    The later versions of GP would sense this and then present a screen where you could delete yourself from 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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans