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.
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 ...Migrate Data Source to SQL Server
To migrate to SQL: 1. Have SQL DBA create a clean database on SQL Server. Have DBA create a user with DBO rights to the database, and get the username/password (SQL authentication) from the DBA (database administrator). 2. In Database tools => select ...Using windows authentication for SQL server
To use Windows Authentication, add service account to "PassagePoint Server" services The account used to start the passagepoint service is the account used to connect to SQL server The SQL context file will need to contain the following string: ...