How to move PassagePont's backend SQL DB to a new SQL server

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:

2) Restore the backup on the new SQL server

if using SQL authentication, have SQL DBA 

1) create user/password on new SQL server with DBO rights
      - get new SQL server, username, password  from DBA

2) update SQL context file with info from above

To encrypt the password see here:






If using windows Authentication, have DBA assign windows user to the new DB and assign DBO rights

With windows authentication, the user is found in the services tab




    • Related Articles

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

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

    • How to repoint a PassagePoint client to an entirely different PassagePoint server

      Pls note. this is to repoint a passagepoint client to a completely different passagepoint server. If you've move the passagepoint server, and need to repoint the client, use this link instead. ...

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

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