Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Patch Manager > Patch Manager - Knowledgebase Articles > 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
/*]]>*/