Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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

Microsoft SQL Server 2008 System CLR Types are missing during installation

Created by Justin Rouviere, last modified by MindTouch on Jun 23, 2016

Views: 331 Votes: 0 Revisions: 5

Overview

The following message similar to the below appears during Patch Manager installation and then the installer window closes:

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

Environment

Patch Manager v2.1.1\

Cause 

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

Resolution

Note: It is recommended to install the x64 and x86 versions for CLR Types and CLR Types 2008 as this is important to the process.

  1. Run the installer until it gets to the first screen. This unpacks all the sub-installers.
  2. Open a CMD prompt
  3. Type 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. Go to SWOrionSetup\SubInstallers.
  5. Look for the following Microsoft SQL Types directories:
    1. Microsoft SQL Server System CLR Types
    2. Microsoft SQL Server System CLR Types 2008
      Note:  This may be under SWOrionSetup\SubInstallers and the Core folder that contains a version number.
  6. In each of these directories, go into both the x86 and x64 sub-directories and run the installer.
  7. If prompted with the Repair or Remove option, select Remove.
    Rerun the installer.
    Otherwise, just run the installer.

 

 

Last modified
01:06, 23 Jun 2016

Tags

Classifications

Public