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