Error with mssqlserver Package When Installing DSC 2019 on Windows 10

Updated May 11, 2020

Reported In

Software

  • LabVIEW Datalogging and Supervisory Control Module
  • LabVIEW

Operating System

  • Windows

Other

  • Microsoft SQL Server 2008 R2 Express

Issue Details

I am using LabVIEW 2019 and when I tried to install Datalogging and Supervisory Control (DSC) Module 2019 on a Windows 10 operating system, I got the following error:

There was a problem executing your request
An error occurred while installing a package: ni-mssqlserver2008r2expr (10.1.0.49152-0+f0)
Please check your Internet connection and try again

 
It showed I have encountered an error when installing Microsoft SQL Server  2008 R2 Express, how could I fix this issue?

Solution

This error could be caused by an incompatibility with the computer's operating system version or due to other instances of SQL Server being installed on the computer.

Windows Compatibility

The Microsoft SQL Server 2008 R2 Express, which is included in Datalogging and Supervisory Control (DSC) Module 2019, does not support Windows 10 versions earlier than version 1809. To resolve this issue, ensure that your Windows build is at least 1809 or download the LabVIEW 2019 DSC f1 patch.


To check what version of Windows 10 you have:

  1. Go to the Windows Start and search Winver.
  2. Run this command.
  3. There will be an About Windows popup that will have details on the version.


To upgrade the Windows 10 build version:

If the version is earlier than 1809, you can upgrade your Windows build by following the steps below:
  1. Go to the Windows Start and search Check for updates.
  2. Click on it to launch the Setting: Windows Update window.
  3. Update your Windows to the latest version, if possible.

Note: The Microsoft SQL Server 2008 is going EOL in September 2019. LabVIEW 2020 DSC Module will address the issue by using the Microsoft SQL Server 2012 Service Pack 4 Express Edition. However, if you need to update the version of SQL when using LabVIEW 2019 DSC Module, download the LabVIEW 2019 DSC f1 patch . For more details about the patch, look at the readme.

Note: In case that you cannot upgrade your Windows version from 1809, due to corporate PC's unable to download updates:
  1. Verify that you have LabVIEW 2019  installed first.
  2. Install SQL SERVER 2019 Express.  
  3. Download LabVIEW 2019 DSC Module as well as the  LabVIEW 2019 DSC f1 patch.

Old Instances of SQL Server

In some cases, an previous installation of SQL Server 2005 or 2008 could be preventing the DSC Module from installing correctly. This can occur if you had an older version of the DSC Module installed previously or if some other software installed SQL Server dependencies.
  1. Check the Windows Add or Remove Programs tool (Start menu>>Control Panel>>Programs and Features) to see what instances of Microsoft SQL Server you have installed on the computer.
  2. If you see that Microsoft SQL Server 2005 or 2008 R2 is installed, determine if you have any non-NI software that relies on these components.
  3. If the answer to step 2 is no, you can follow the instructions from Microsoft to uninstall SQL Server 2005 and SQL Server 2008. If you have trouble removing these components, contact Microsoft support for assistance.
  4. After these components are removed, restart you computer.
  5. Attempt to install the DSC Module again.

Additional Information

You must have LabVIEW 2019 installed before you can install the LabVIEW 2019 DSC Module .