Use MSSQL database instead of PostgreSQL

Use MSSQL database instead of PostgreSQL

If you want to use SQL, after PassagePoint has been installed >> go to \PPGlobal\config delete the first 'sqlcontext.xml' file.
Then rename the 'sqlcontext.xml.mssql' to 'sqlcontext.xml'

Here - edit the new updated 'sqlcontext.xml'

You will need to update the database string, user and password.

The user will need DBO owner.

​

After you have made the connection. You can encrypt the password by opening command prompt -

cd to \PPGlobal\config

enter encrypt followed by your password