in10se

Post · · 4 min

Best Practice Oxford SP1: the database connector, the firewall rule and approving each computer

What Bp Premier Oxford SP1 changes on the server, the network and every workstation, and the checks we run before and after the upgrade.

By in10se · practice software updates, best practice

Best Practice Software released Bp Premier Oxford SP1, version 1.14.1.1129, on 4 September 2026. It changes how every computer in the practice connects to the Bp database.

SP1 or SP2

Best Practice released Oxford SP2, version 1.14.2.1135, on 2 November 2026. A practice that has not installed Oxford yet can go straight to SP2, as long as it is on Orchid SP1 Revision 1 or later. Check the server first. SP2 needs SQL Server 2019 or later and the August 2026 data update or later. If the server runs SQL Server 2016 or 2017, SP2 does not support it, and SP1 is the release that server can take until SQL Server is upgraded.

SP2's release notes list what changed since SP1, and the Database Connector is still part of it. A practice that goes straight to SP2 should plan for the SP1 changes below in the same upgrade.

What changed

  • A new Windows service on the server. The update installs the Best Practice Database Connector. Each practice now has its own database access password.
  • A firewall rule. Workstations reach the connector through an inbound firewall rule on the server. With Windows Defender Firewall, the installer tries to add the rule itself. With another firewall product, the rule may need to be added by hand. Best Practice suggests talking to your IT provider before installing if you are unsure.
  • Approving computers. A new tool, the Database Password Access Manager, controls which computers can collect the database credentials. Computers that used Bp in the past 12 months should be approved automatically, though some may need approving after their first login. A new computer starts as Pending and cannot open Bp until someone approves it. Where staff work in virtual machines, only the virtual machine needs approving.
  • Medical devices. Best Practice warns that ECG, spirometry and blood pressure devices may fail to connect or import results after the update.
  • Utilities. The Reporting Tool, the Bp Payments Utility and the NCSR Utility have their own updates, to go on workstations before SP1. The NCSR Utility also needs the FHIR API updated on the server.
  • Assignment of benefit. SP1 carries the changes for 1 July 2026. A new setting under Online Claiming turns assignment of benefit on, and it cannot be turned off again. Patient details gain an enduring assignment checkbox, and verbal or enduring consent can be made the default. It also fixes invoices dated after 1 July 2026 not appearing in batches.

To install SP1, the practice must be on Orchid SP1 Revision 1 or later, with the April 2026 data update or later installed first. Best Practice supports Windows 10 Pro or later, Windows Server 2016 or later and SQL Server 2016 or later. The first Oxford release, from June, was withdrawn after the government changed the assignment of benefit timeline on 18 June, and SP1 replaced it.

What it means for your clinic

  • The upgrade touches three things beyond Bp itself: the server, the firewall and every computer. Plan it as a small project, outside business hours, with everyone logged out.
  • A locum's laptop or a replacement computer will not open Bp until it is approved. Someone in the practice needs the Setup/Configuration permission set to Add/Edit/Delete, and needs to know where the approval screen is.
  • If the ECG or spirometer stops importing the morning after, those results stop reaching the patient record until it is fixed.

What we would do if we looked after your practice

  1. Back up the Bp database and test a restore before the upgrade night.
  2. Install the latest data update, and update the Reporting Tool, Payments Utility and NCSR Utility on the computers that use them.
  3. List every computer that opens Bp, including laptops and virtual machines, and every medical device that sends results to it.
  4. Check which firewall protects the server, and add the connector rule ourselves if it is not Windows Defender Firewall.
  5. Synchronise any workstations in remote database mode, then run the upgrade to SP1 or SP2 on the server and every workstation.
  6. Check access on the supported computers and arrange for clinic staff to validate connected medical devices with the vendor’s guidance.
  7. Agree claiming and printing checks with the practice, with clinical and billing validation performed by its authorised staff.
  8. Write the approval steps into the practice's IT procedures, so a new computer next year does not stop someone working.

Best Practice upgrades, done out of hours, are part of our IT support, which starts at $550 a month for up to 8 devices.

If you would like the upgrade done for you, we can book an evening that suits the clinic. Ask through the contact form. We reply within one business day. Our Best Practice page covers how we look after practices on Bp Premier.

Sources: Best Practice Software's Bp Premier Oxford SP1 release notes and Oxford SP2 release notes, read on 3 and 6 November 2026.

Pricing and information in this post were accurate at the time of writing. Contact us for current pricing.

Your clinic deserves technology that just works.

Let’s start with a 15-minute call to get to know your practice and what you need help with. We can then talk through the next step.