Uninstall Bp Premier and SQL Server

Uninstalling Bp Premier completely requires you to:

  1. Remove the Bp Premier program.
  2. Delete any remaining registry entries.
  3. Remove the \Program Files\Best Practice Software folder.
  4. Stop Bp-related Windows Services.
  5. Remove the SQL Server database.

Bp Premier uninstallation will require administrator permissions to remove software and configure Windows components. Before starting any of the instructions below, log in to the server computer as a Windows Administrator, or have your IT support carry out the installation. If you have Windows User Access Control or SmartScreen enabled, Windows will prompt for confirmation to proceed for some instructions.

IMPORTANT  If you are using a live version of Bp Premier and are uninstalling the server, always perform a backup of the Bp Premier database and test a restore before uninstalling the database. See Back up and restore Bp Premier for more information.

Uninstall Bp Premier

Follow the instructions below to completely uninstall a Bp Premier client or server.

Remove the Bp Premier program

  1. On the computer on which you are uninstalling Bp Premier, close Bp Premier and any windows and applications you have open.
  2. Open Windows Add and Remove Programs. The path will depend on the version of Windows, but is available from StartControl Panel.
  3. Select Bp Premier in the list and click Uninstall.
  4. NOTE  The following example shows how to uninstall Bp Premier from Add and Remove Programs in Windows 10. The process is similar, but the screens may be different to your version of Windows. If you need help uninstalling the program, your IT support can assist.

    Uninstall Bp Premier

  5. A User Access Control popup may request confirmation that you want to remove the software. Click Yes. The Windows Installation uninstall program will appear.
  6. Installation Uninstall program

  7. Leave Automatic selected and click Yes. Click Finish in the next screen. Windows will remove the major components of Bp Premier and exit the uninstaller.
  8. Delete registry entries

  9. Open the Windows command prompt or Run dialog, type 'regedit', and press Enter. Or search for 'registry editor' in the Windows search bar. The Windows Registry Editor wil appear.
  10. Delete the following folders:

    • HKEY_CURRENT_USER \ Software \ Best Practice Software
    • HKEY_CURRENT_USER \ Software \ Wow6432node \ Best Practice Software (if computer is 64-bit)
    • HKEY_LOCAL_MACHINE \ Software \ Best Practice Software (if computer is 32-bit)
    • HKEY_LOCAL_MACHINE \ Software \ Wow6432node \ Best Practice Software (if computer is 64-bit)

    To delete a folder, expand the tree until the folder is visible, right-click, and select Delete.

    Delete registry key

  11. Close the registry editor.
  12. Remove the Best Practice Software folder

  13. In a Windows file explorer, browse to C:\Program Files.
  14. Right-click the folder Best Practice Software and select Delete. A message will display: ‘Are you sure you want to move this folder to the Recycle Bin?' Click Yes.
  15. Windows may alert that files in the folder you are trying to delete are still in use. If so, you must stop some services before you can delete the folder.

    Stop services

  16. Go to Start or AppsControl PanelAdministrative ToolsServices to open the Services window. The exact path will depend on your version of Windows.
  17. Right-click on the following services and select Stop:
    • Best Practice NPS Service
    • Best Practice Service
    • Best Health App Receiving Service
    • eRx Standard Adapter Service
    • eRx Standard Adapter Store and Forward Service

    Stop service

  18. Close the services screen.
  19. Repeat steps 9–10 to delete the Best Practice Software folder.
  20. Uninstall SQL Server database

  21. Follow the instructions in the section that applies to your Windows version:
  22. In the Services window, check if the service SQL Server (BPSINTANCE) exists. If this service is still running, you have not fully deleted the SQL Server database.
  23. Restart the computer.

Bp Premier is now completely uninstalled.

Uninstall the database

The instructions below describe how to completely uninstall an Express edition of SQL Server. If your practice uses a full edition of SQL Server, Best Practice Software recommend consulting your IT support or database administrator to uninstall the full SQL Server edition database

SQL Server uninstallation will be slightly different depending on the version of SQL Server that was installed. The instructions below describe how to uninstall Bp Premier for SQL Express 2008 R2 on a variety of operating systems. The process will be very similar for any later Express edition of SQL Server.

IMPORTANT  The instructions in this section assume that only Bp Premier uses SQL Server installed on the Bp Premier server, and will completely remove all SQL Server functionality. If you have other applications installed on the Bp Premier server computer that use SQL Server, do not remove SQL Server shared features, and only remove the BPSINSTANCE database. Best Practice Software recommend consulting your IT support or database administrator if you need to uninstall the Bp Premier database in a shared environment.

Which version of SQL do I have installed?

  1. Log in to Bp Premier on the server that you are about uninstall.
  2. Select Help > About > System info from the main screen.
  3. Scroll to the bottom of the list to where it says SQL Server Version.

Version number

Named version

8.00 Desktop Engine

SQL MSDE (Microsoft SQL Desktop Engine)

9.00

SQL Server 2005

10.0

SQL Server 2008

10.50

SQL Server 2008 R2

11.0

SQL Server 2012

12.0

SQL Server 2014

13.0

SQL Server 2016

Uninstall SQL Server on Windows Server 2003 or Windows XP

  1. Log in to Bp Premier on the machine you are uninstalling.
  2. Go to Help > About > System Info.
  3. Record the Server data path (the folder will be manually cleared later).
  4. System information server data path

  5. Close Bp Premier.
  6. Click on Start > Control Panel > Add or Remove Programs. The Add / Remove Programs screen will appear.
  7. Select Best Practice SQL Express Edition.
  8. Click Change/Remove. The Select Uninstall Method screen will appear.
  9. Select Automatic and click Next. The Perform Uninstall screen will appear. Click Finish to complete the uninstall process.
  10. You may be prompted to reboot the machine. If you are uninstalling from the server, make sure that no users are accessing the machine before rebooting. Return to the Add / Remove Programs screen after the reboot.
  11. From the Add / Remove Programs screen, select Microsoft SQL Server 2008 R2 and click Change/Remove. The SQL Server 2008 R2 Add / Repair / Remove screen will be displayed.
  12. Click Remove. The Setup Support Rules screen will appear and will run through the Setup Support rules validation.
  13. Click OK. The Select Instance screen will appear.
  14. Select BPSInstance if you are uninstalling from a server, or select BPSClient if you are uninstalling from a workstation.
  15. Click Next. The Select Feature screen will appear.
  16. Click Select All to remove all components. Click Next. The Removal Rules screen will appear.
  17. Click Next to continue. The Ready to Remove screen will appear.
  18. Click Remove to continue. The Removal Progress screen will appear and the removal of SQL will proceed. The Complete screen will be displayed when the removal process has completed.
  19. Click Close to continue. The next step is to remove the legacy files and folders that cannot be removed by the automated install.
  20. Using Windows file explorer, browse to the 'Microsoft SQL Server' folder of the database path that was recorded in step 3.
  21. For example, if the database path is:

    C:\Program Files\Microsoft Sql Server\MSSQL12.Bpsinstance\MSSQL\Data\

    browse to the folder C:\Program Files\Microsoft Sql Server\.

  22. Delete the entire 'instance' subfolder. In the example above, delete the folder 'MSSQL12.Bpsinstance'.
  23. If Windows prevents you from deleting any files in the subfolder, you may not have permission to delete the files, or a service may still be running. Contact your Network Administrator for advice.

Bp Premier uninstallation is complete.

Uninstall SQL Server on Windows Server 2008 R2

  1. Log in to Bp Premier on the machine you are uninstalling.
  2. Go to Help > About > System Info.
  3. Record the Server data path (the folder will be manually cleared later).

    System information server data path

  4. Close Bp Premier.
  5. Select Start>Control Panel.
  6. Select User Accounts and click Change User Account Control Settings.
  7. Make sure that the Use User Account Control (UAC) to help protect your computer option is disabled or set to never notify. If turned on, turning UAC off will instigate a reboot of the computer.
  8. From the Control Panel, under Programs, click Uninstall a Program. The list of installed programs will appear.
  9. Right-click Best Practice SQL Express Edition and select Uninstall. The Select Uninstall Method screen will appear.
  10. Select Automatic and click Next. The Perform Uninstall screen will appear.
  11. Click Finish to complete the uninstall process. You may be prompted to reboot the machine. If this is the server, make sure that no users are accessing the machine before rebooting.
  12. Click on Start > Control Panel > Programs > Programs and Features.
  13. Right-click Microsoft SQL Server 2008 R2 and select Uninstall. The SQL Server 2008 R2 Add / Repair / Remove screen will be displayed.
  14. Select Remove.
  15. The Setup Support Rules screen will appear and will automatically run through the Setup Support rules validation.
  16. Click OK.
  17. The Select Instance screen will appear. Select BPSInstance if you are uninstalling from a server or BPSClient if you are uninstalling from a workstation.
  18. Click Next.The Select Feature screen will appear. Click Select All to remove all components.
  19. Click Next. The Removal Rules screen will appear.
  20. Click Next to continue. The Ready to Remove screen will appear.
  21. Click Remove to continue. The Removal Progress screen will appear and the removal of SQL will proceed.
  22. The Complete screen will be displayed when the removal process has completed. Click Close to finish.
  23. Using Windows file explorer, browse to the 'Microsoft SQL Server' folder of the database path that was recorded in step 3.
  24. For example, if the database path is:

    C:\Program Files\Microsoft Sql Server\MSSQL12.Bpsinstance\MSSQL\Data\

    browse to the folder C:\Program Files\Microsoft Sql Server\.

  25. Delete the entire 'instance' subfolder. In the example above, delete the folder 'MSSQL12.Bpsinstance'.
  26. If Windows prevents you from deleting any files in the subfolder, you may not have permission to delete the files, or a service may still be running. Contact your Network Administrator for advice.

Bp Premier uninstallation for MS SQL Server 2008 R2 is complete.

Troubleshooting

Install.log error

If you receive the error ‘Install.log cannot be found’ while trying to install the software, this usually means that a previous Bp Premier installation did not complete successfully. Follow the instructions in this section to completely remove all components of a previous installation, and retry the installation.