Tech Tips – OneSource

Tech Tips – OneSource
May 21, 2019 Kelley DeMarchi

OneSource installation is failing to complete.

Below are some tips for to successfully install OneSource.

Reboot the Terminal/Manager machine prior to starting the OneSource install and after any software is uninstalled.

Right-click OneSourceSetup.exe and click “Run as Administrator.”

Make sure that the necessary Network ports are open (1001, 1002, 1433, 1443, 1444, 4443). Contact your local IT or Horizon Software support if you need assistance with creating the Firewall Port Exceptions.

If you installed Microsoft SQL Server, prior to installing OneSource, uncheck the option for Microsoft SQL Express Database. Enter your Instance name at the Server Location prompt. It should look something like this: (local)MySQLInstance (substitute your instance name for MySQLInstance, if you installed a Named SQL Instance).


Can I do a standalone install of SQL Server Express prior to installing OneSource?

SQL Server Express can be installed prior to installing OneSource. If you used a Named Instance during your SQL Install, you have to provide that information to OneSource.  On the Server Location screen, enter the Server Path.

For example, you would enter (local)MySQLInstance (substitute your instance name for MySQLInstance if you installed a Named SQL Instance).


I selected a PREVIOUS date range and printed the Student Roster. The Student Eligibilities and Counts don’t match other reports for that same date range.

The Student Roster Report is NOT historical. It will always reflect the Student’s current Eligibility. The Date criteria relates to the processing of the Application, NOT the Student Eligibility, for a specific date range. You must print/save the Student Roster, on the specific date, to capture the Eligibility for that date.


On the Basic Claims Report, the Student Counts and Highest Enrollment numbers are higher than any of the other Reports.

The only time the numbers will match is when you run the Basic Claims Report for a single day (or if the numbers never change, which is unlikely). When you run the Basic Claims Report, for a Date Range, the numbers are as follows:

Student Counts – Displays the highest eligible Free, highest eligible Reduced applications and highest eligible Full Pay, from any date in the date range. A student will be counted in multiple categories, within the date range, if their eligibility changed, during that time.

Highest Enrollment – Displays the sum of the largest enrollment for the date range, by eligibility category.

Using the example below:

Date Free Reduced Full Pay Daily Total
2018-08-13 476 40 202 718
2018-08-14 476 42 194 712
2018-08-15 471 42 194 707
2018-08-16 474 42 190 706
2018-08-17 473 42 192 707

Student Counts:

Free = 476 (occurs on multiple dates)

Reduced = 42 (occurs on multiple dates)

Full Pay = 202

Highest Enrollment = 720

The Highest Enrollment number exceeds any of the Daily Totals because student’s eligibilities changed, during the date range.