How to encrypt the SQL server password in the SQLcontext.xml file

To encrypt the password:

    a. open command prompt cd\ to the root of c:

    b. cd to ppglobal\config

    c. enter 'encrypt mypassword' where mpassword is your password

    d. Copy the encrypted string and replace the password

 Save the 'sqlcontext.xml'

• 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 repoint PassagePoint to a new SQL server

  PassagePoint keeps the SQL server connection string in the "sqlcontext.xml" file on the passagepoint application server. see path below: \\PPGlobal\config\sqlcontext.xml To repoint: Edit the 'sqlcontext.xml' You will need to update the database ...

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

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