Note, this tip is for GP Administrators only. Attempts by non-administrators to change the system password could compromise data security!
Occasionally, the GP system password is forgotten or lost. This password is required to make changes at the system level, such as adding a new user, changing user security, etc. Here's how to recover when this happens.
1. In SQL Management Studio, run this script to remove the existing password -
SET PASSWORD = 0x0202020202020202020202020202020
2. In GP, reset the system password.
* click image to enlarge
Now, store the password in a safe, accessible place!!