Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

Home > Success Center > Patch Manager > Microsoft SQL Server 2008 System CLR Types are missing during the installation

Microsoft SQL Server 2008 System CLR Types are missing during the installation

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.

Environment

Patch Manager v2.1.1

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.

 

 

Last modified

Tags

Classifications

Public