Friday, August 29, 2014

Resetting System password in Dynamics GP

Forgot your Dynamics GP system password?

They system password is stored in the SY02400 table located in the Dynamics database.  It is not recommended to remove or reinsert a record in this table.

Here is a simple script to reset the system password allowing the user to  redefine it.

Note:  It is highly recommended that you backup your database before trying out these commands or any other scripts.


UPDATE DYNAMICS..SY02400 SET DMYPWDID=1, PASSWORD = 0x00202020202020202020202020202020

Post your comments regarding to this blog.

Natarajan S


  1. Thanks for this... its helped me a lot....

  2. so 3 years since your post and you save dme big tim. Thank you very much had spent a long time troubleshooting this and you saved me longer