sqlContext.xml file format changed (6450 and higher)

As the format of the "sqlcontext.xml" has changed, after the upgrade is complete, copy your settings to the new "sqlcontext.xml", then rename yours to sqlcontext.xml.old, and the new one to sqlcontext.xml.


1) open sqlcontext.xml, and sqlContext.xml.mssql with notepad, side by side.





2) copy your settings and replace the "New One". See below.




3) now rename sqlContext.xml to "sqlContext.xml.old", and rename sqlContext.xml.mssql to "sqlContext.xml"





4) restart service.

• Related Articles

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

• HL7 verbose logging (6432 and higher)

  To turn on Verbose logging for HL7 Rename your current log settings to log4j2_old.xml Replace with attached log4j2.xml, then restart the passagepoint service.

• What is the import order for the Web Pre-reg group registration Tab Delimited Text file?

  The text file must meet with the following requirements: 1. Column header is required and should be included as the very first line, and should specify the following header names (case insensitive) 1. first: column for person first name, REQUIRED 2. ...

• How to send an ical file in the visitor notification email

  Follow the steps below to send an ical file in the visitor notification email: Login to the desktop client with admin rights. Navigate to: Home > Configure System > Communication Settings > Under the Configured E-mail Templates section, select and ...

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