Error with mssqlserver Package When Installing DSC 2019 on Windows 10

Updated Dec 15, 2022

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 or the DSC Runtime 2019 on a Windows 10 operating system, I got the following error related to Microsoft SQL Server 2008 R2 Express:

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


The error is shown in the following dialog box:
 
 

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.

In case 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 DSC Module 2019 as well as the  LabVIEW 2019 DSC f1 patch. To review more information about the patch, please refer to its readme.
Note: The LabVIEW 2019 DSC f1 patch will not work with the DSC Runtime 2019. If you want to install just the Runtime version, upgrade your Windows 10 build version or review if there are any old instances of SQL Server that could be interfering with the software installation as explained in the section below. 

Old Instances of SQL Server

In some cases, a 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 your computer.
  5. Attempt to install the DSC Module again.

Additional Information

The Microsoft SQL Server 2008 has gone EOL last September 2019. The LabVIEW DSC Module 2020 has addressed this issue by using the Microsoft SQL Server 2012 Service Pack 4 Express Edition.