Reset passagepoint Admin password with SQL server Backend
If you don't know what back end DB you are running, see here first:
If PassagePoint is running Postgresql, see this:
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';
Related Articles
How to Reset the Admin password (PostgreSQL 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 for SQL backend see here: Reset passagepoint Admin password with SQL server Backend ...How to connect to Microsoft SQL database and encyrpt user password
Note: For windows authentication see KB article https://support.stopware.com/portal/en/kb/articles/sqlcontext-for-windows-authentication For SQL Authentication see instructions below. If TLS is required, see attachements. 1) Create a clean database ...How do I move PassagePoint global to a different server?
How do I move PassagePoint Global to a different server? Source Machine = Production server is the customer's server that contains the PassagePoint Global “config” folder and database Destination Machine = New server for the PassagePoint Global ...How to move PassagePont's backend SQL DB to a new SQL server
To move PassagePoint to a new SQL server: 1) Do a full backup of the passagepoint DB on the current SQL server if you don't know which SQL server or what DB it is, see here: ...How to repoint PassagePoint to a new SQL server
PassagePoint keeps the SQL server connection string in the "sqlcontext.xml" file on the passagepoint application server. see path below: \\PPGlobal\config\sqlcontext.xml To repoint: Edit the 'sqlcontext.xml' You will need to update the database ...