Reset Wonderware Administrator Password

If you get locked out of the Wonderware Galaxy and need a login, but can get into the database with write permissions, use the following SQL script on the Galaxy database to reset the Administrator password to: 123456

First find the user_profile_id of the Administrator user using the following script:

SELECT user_profile_id FROM dbo.user_profile WHERE user_profile_name = 'Administrator'

Most likely this will be a value of 2. If so, just run the following script to update the password, otherwise, use the script and just change the user_profile_id from 2 to whatever number you got with the first query.

UPDATE dbo.user_profile SET user_guid='f10f8ca3-15f4-4a26-937a-a45532036ea5', password_hash=2039933623 WHERE user_profile_id=2;