Upgrade SQL Server

The instructions below show how to upgrade the version or edition of Microsoft SQL Server. For example, follow the instructions to upgrade from:

  • SQL Server 2008 R2 Express to SQL Server 2016 Express (upgrading the version)
  • SQL Server 2016 Express to SQL Server 2017 Standard (upgrading the edition)

This Microsoft knowledge base article on upgrading to SQL Server 2017 can provide more information on upgrade compatibility.

Upgrading from the Express edition to a Standard or Enterprise edition is necessary if your database is approaching the 10 Gb size limit for the Express edition.

These instructions can be used if you are running the following Bp Premier versions:

Build Number

Version name

1.8.4.642

Summit

1.8.5.754

Lava

1.8.6.801

Lava SP1

1.8.7.804

Lava SP2

1.8.8.810

Lava SP3

1.9.0.846

Indigo

1.9.0.856

Indigo Revision 1

1.9.1.863

Indigo SP1

1.9.1.864

Indigo SP2

1.10.0.880

Jade

1.10.1.886

Jade SP1

1.10.2.893

Jade SP2

The example below shows upgrading to SQL Server 2017. The screens on your server may appear slightly different, depending on your version of Windows, but the upgrade process is the same.

Before you begin

You will need the installation media for the version or edition of SQL Server you are upgrading to. This might be in the form of a DVD, or an executable installer that you have downloaded and unpacked from a Microsoft SQL Server internet resource.

Back up your existing database immediately prior to the upgrade.

Upgrade SQL Server version or edition

  1. If your SQL Server install media is on a DVD, insert the DVD into the Bp Premier server.
  2. In a Windows File Explorer, navigate to the DVD or the folder containing the install files. Double-click the file Setup.exe.
  3. Upgrade SQL Server

  4. The SQL Server Installation Wizard will open. Click the option Upgrade from a previous version of SQL Server.
  5. SQL Server Upgrade choose upgrade type

  6. Tick Accept the license terms and click Next.
  7. SQL Server Upgrade accept license

  8. Tick Use Microsoft Update to check for updates (recommended) if your practice wishes to check for updates to SQL Server automatically. Ticking or not ticking this option will not affect installation. Your practice's IT policies will determine if you should tick this option. Click Next
  9. SQL Server Upgrade check for updates

  10. Select the SQL Server instance you want to upgrade and click Next.
  11. SQL Server Upgrade select instance

  12. The installation wizard will begin running rule checks. If you are upgrading to SQL Server 2012 or higher, the following message will appear twice during the upgrade: 'Login failed for user *\BpAdmin. Reason: The account is disabled.' Click Cancel to proceed with the installation every time this message appears.
  13. SQL Server Upgrade account disabled message

    IMPORTANT  This message is generated because of changes to database access in recent versions of Bp Premier, and is the only message that you can safely click Cancel on to proceed with the upgrade. If you receive any other error messages, you will have to handle those error messages case by case.

  14. The following screen will appear when SQL Server upgrade is complete.
  15. SQL Server Upgrade complete