You receive a message that states that the user is currently logged on when you try to log on to Microsoft Dynamics GP

Article ID: 864384 - View products that this article applies to.
Expand all | Collapse all

Symptoms

When you try to log on to Microsoft Dynamics GP or to Microsoft Business Solutions - Great Plains, you receive a message that states that the user is currently logged on. Additionally, you cannot log on. This problem occurs even when no users are logged on to Microsoft Dynamics GP.

Cause

This problem may occur if a user logon session is active.

Resolution

To resolve this problem, follow these steps:
  1. Log on to Support Administrator, Query Analyzer, or Management Studio depending on what version of SQL you run.
    Notes
    • If you are using Microsoft SQL Server 2005, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2005, and then click SQL Server Management Studio.
    • If you are using Microsoft SQL Server 2008, start SQL Server Management Studio. To do this, click Start, point to All Programs, point to Microsoft SQL Server 2008, and then click SQL Server Management Studio.
    • If you are using SQL Server 2000, start SQL Query Analyzer. To do this, click Start, point to All Programs, point to Microsoft SQL Server, and then click Query Analyzer.
    • If you are using SQL Server Desktop Engine (also known as MSDE 2000), start Support Administrator Console. To do this, click Start, point to All Programs, point to Microsoft Administrator Console, and then click Support Administrator Console.
  2. Run the following script to remove the user from the ACTIVITY table:
    delete DYNAMICS..ACTIVITY where userid='username'
    Note Replace Username with the user ID of the user receiving this message.
  3. If a batch-related task is being performed with the user receiving this message, run the following script to remove the session from the Batch Activity table:
    delete DYNAMICS..SY00800 where userid='username'
    Note Replace Username with the user ID of the user who was logged on to Microsoft Dynamics GP.

Properties

Article ID: 864384 - Last Review: July 13, 2012 - Revision: 5.0
Applies to
  • Microsoft Dynamics GP 2010
  • Microsoft Dynamics GP 10.0
  • Microsoft Dynamics GP 9.0
  • Microsoft Business Solutions–Great Plains 8.0
  • Microsoft Business Solutions–Great Plains 7.5
  • System Manager
Keywords: 
kbexpertisebeginner kbtshoot kbprb kbexpertiseinter kbmbsmigrate KB864384

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com