How to set up passagepoint to talk to an encrypted SQL server DB

How to set up passagepoint to talk to an encrypted SQL server DB

When Data at rest is required to be encrypted, STOPware recommends using SQL server, and using native SQL server data encryption.

Once that is done on the SQL server side, on the passagepoint side, pls see attached sqlcontext.xml on how to configure passagepoint to enable communication to sql server via TLS 1.2

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

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

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

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

    • How to repoint a PassagePoint client to another PassagePoint server

      Please follow these steps to point a PassagePoint client to another PassagePoint server. Right Click on the PassagePoint icon and hit ‘Open File Location’ Open the “Client” folder (C:\PPGlobal\Client) delete imgCache delete jarCache delete ...