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;

This query should combine the above 2 queries into a single line to reset the administrator password automatically to 123456:

UPDATE dbo.user_profile
SET user_guid = 'f10f8ca3-15f4-4a26-937a-a45532036ea5', 
	password_hash = 2039933623
WHERE user_profile_id=(
    SELECT user_profile_id
    FROM dbo.user_profile
    WHERE user_profile_name = 'Administrator'
	);