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

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

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