Reset passagepoint Admin password with SQL server Backend

Reset passagepoint Admin password with SQL server Backend

If you don't know what back end DB you are running, see here first:
https://support.stopware.com/portal/en/kb/articles/what-backend-database-am-i-running

If PassagePoint is running Postgresql, see this:
https://support.stopware.com/portal/en/kb/articles/how-to-reset-the-admin-password-postgresql-backend

With SQL Server Backend:

Using MS SQL Management Studio

Run the following script against the passagepoint DB, then restart the passagepoint service.

This will set the password to blank. When logging in with the admin, just leave the password blank.

UPDATE X1_USERACCOUNT
SET x_password = '1B2M2Y8AsgTpgAmY7PhCfg=='
WHERE x_login = 'admin';