GP #LifeHacks 113: Resetting Forgotten System Password

Some of the administrator type functions in Dynamics GP use a system password in order to provide a thin layer of protection against unintentional and/or inappropriate use.
This password often gets misplaced, forgotten, or just disappears with turnover.
I have some good news for you if you fall into this situation… A SQL Script can be used to reset the password.

Resetting the System Password

I feel compelled to share that this is NOT the SA password… that is something very different.
Run the script below.  This will make the system password ‘blank’ allowing you to go into GP and reassign a system password.  Be sure to take the appropriate precautions (backup, backup, backup!) before running the script below, it never hurts to have a backup. 🙂

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

Navigate to ‘Administration/Setup/System/System Password’ in order to find the system password window.
After resetting it to blank, you can simply put in the new password.  Do yourself a favor, keep it in a safe place – and no… not on a sticky under your keyboard 🙂

Thanks for reading!

Shawn Dorward
Microsoft MVP, Business Solutions| LinkedIn | Twitter | GPUG | MSDYNGP
Original Post:

Leave a Reply