Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Patch Manager > Unable to install Patch Manager because SQL CLR types missing

Unable to install Patch Manager because SQL CLR types missing

Created by Leif Amland, last modified by MindTouch on Jun 23, 2016

Views: 171 Votes: 0 Revisions: 5


This article provides brief information and steps to resolve the following error while installing Patch Manager:


Setup is missing an installation prerequisite:

-Microsoft SQL Server 2012 System CLR Types. To continue, install SQL Server 2012 System CLR Types from and then run the Setup operation again. 




All Patch Manager versions



The Microsoft SQL Server CLR types have been removed.

The link that Microsoft provides is to the Microsoft SQL Server 2008 download which will not help the installation of Patch Manager. You will also see that every file for Microsoft SQL Server CLR types are the same file name so be careful what you save them as.


  1. Go to link that you need the CLR type for, expand INSTALL INSTRUCTIONS and scroll down to the Microsoft SQL CLR types and download the version you are missing.


   2. Once the CLR types that were missing have been installed there is no restart required. You can restart the Patch                Manager installer and it should be successful.




Last modified
01:20, 23 Jun 2016