Dynamics GP10 Database Migration RRS feed

  • Question


    We have migrated Dynamics GP10 database from SQL server to new server with SQL2008R2, we run the sql script to migrate the logins and also Dex_req.sql and Grant.sql  according to Microsoft kb878449, after we reconnect GP client to the new DB server it is working fine after resetting the user password, But when trying to open User Security Setup  from Administration on GP the following message will appear “ this user ID is being edited by another user”

    What may be the issue? Informing that the new SQL server 2008R2 is installed by same Collation and same sort order

    Kind Regards, Reda Kotb Network Administrator Direct: +966 2 6572029 ext 808 reda.kotb@ibscoksa.com

    Monday, February 20, 2012 11:37 AM


  • Hi Reda,

    For the issue “ this user ID is being edited by another user”, since this is a Dynamics GP issue more than a SQL Server issue. Suggest you post this error to Dynamics GP forum for more support.

    Here is the MS Dynamics GP forum:


    Best Regards,
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    • Marked as answer by Iric Wen Tuesday, February 28, 2012 8:57 AM
    Wednesday, February 22, 2012 2:02 AM