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 ...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 ...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 ...