We use cookies on our website to provide you with the best experience. If you continue browsing, you are consenting to our use of these cookies, but if you would like to know more, including how you can change your settings, take a look at our Privacy Notice.

How to install the SQL Backward Compatibility Components for use with Sage 50 Manufacturing

We strongly recommend that all users of Sage 50 Manufacturing have installed the SQL Backward Compatibility Components to ensure full functionality is possible. It also reduces the likeliness of errors occurring which may prevent access to the software. This article explains how to download and install the components.

Attempting to take a backup without the SQL Backward Compatibility Components installed on the client machine may give the following error: 'The SQL Server is not available on the network. Please consult your network administrator.' 

Note: As this software is not owned by Sage, this article is written as a goodwill gesture only. If you experience any problems in completing the installation, please refer to the Microsoft website or your IT support team.

To install SQL 2005 Backwards Compatibility components

  1. Visit the Microsoft website to download the required components.
  2. Note:  This link will open in a separate window so you can continue to follow the steps in this article whilst completing the download.
  3. Expand the Install Instructions section.
  4. Scroll down the page until you arrive at the section entitled 'Microsoft SQL Server 2005 Backward Compatibility Components'.
  5. There are three different downloads available. The download you require will depend on the type of PC you are using:
    • X86 Package (SQLServer2005_BC.msi) - For 32-bit PCs
    • X64 Package (SQLServer2005_BC_x64.msi) - For 64-bit PCs
    • IA64 Package (SQLServer2005_BC_ia64.msi) - For 64-bit Itanium PCs.
  6. Select the relevant filename. Depending on your default browser, you'll be prompted to either Save or Run the file. Choose Run.
  7. From the Setup Wizard, select Next.
  8. You must accept the terms in the licence agreement to continue. Select the radio button > Next.
  9. Enter a suitable Name and Company > Next.
  10. Leave the feature selections unchanged > Next.
  11. Select Install.
  12. Once the installation has completed, select Finish.

You can then begin using Sage 50 Manufacturing. If you have not installed the software and require assistance, please refer to Ask Sage article 27895.