System Password Reset in Microsoft Dynamics GP
Friday, December 4th, 2009On a recent project I was on, we needed to access areas of Dynamics GP that were protected with a system password. However, we didn’t know the password on that particular environment, so I needed a way to reset it. I looked up for a solution and found an interesting answer.
I know that the system password is stored in SY02400 table and that this should be my point of interest. The query should be something like ‘UPDATE DYNAMICS..SY02400 SET PASSWORD =’. However, the interesting part is how to set the password to blank. The code segment “0×00202020202020202020202020202020″ represents “Blank” string in binary.
Therefore, in case you forgot your system password, just execute this query:
UPDATE DYNAMICS..SY02400 SET PASSWORD = 0×00202020202020202020202020202020
