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 to test for SQL server connetivity using MS ODBC manager

  When PassagePoint fails to connect to SQL server, it's possible to use windows ODBC manager to test the connection to SQL server. If you don't know what sql server passagepoint connects to, see the "sqlcontext.xml" file, Ile is in ...

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

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