Security Compliance

Microsoft SQL Server 2008 System CLR Types are missing and they have to be re-installed.

This article addresses the following message that displays when the Patch Manager installer inadvertently closes during the installation: Microsoft SQL Server 2008 System CLR Types are missing and they have to be re-installed.

First published date

10/11/2018 6:17 PM

Last published date

10/25/2021 6:29 PM

Overview

This article addresses the following message that displays when the Patch Manager installer inadvertently closes during the installation: 

Microsoft SQL Server 2008 System CLR Types are missing and they have to be re-installed.

Product section

Patch Manager

Cause

Patch Manager and specifically the SQL pre-requisites were uninstalled and attempted to be installed again.

Resolution

SolarWinds recommends installing the x64 and x86 versions for CLR Types and CLR Types 2008, which is important to the process.

  1. (Recommended) Install the x64 and x86 versions for CLR Types and CLR Types 2008. This is important to the process.
  2. Run the installer until it gets to the first screen. This unpacks all the sub-installers.
  3. Open a CMD prompt and execute:
    cd %TEMP%.
    The installer unpacks to where the temp folder is located For example, C:\windows\temp\and C:\Users\your-username\AppData\Local\Temp.
  4. Navigate to SWOrionSetup\SubInstallers.
  5. Locate the following Microsoft SQL Types directories:
    • Microsoft SQL Server System CLR Types
    • Microsoft SQL Server System CLR Types 2008
      This directory may be under SWOrionSetup\SubInstallers and the Core folder that contains a version number.
  6. In each directory, access the x86 and x64 sub-directories and run the installer.
  7. If prompted with the Repair or Remove option, select Remove.
  8. Rerun the installer.