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:
<value>jdbc:sqlserver://<host>:<port>;databaseName=amber;integratedSecurity=true;</value>
See attached sample file for a sample.
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 ...
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 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 ...
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 ...