Microsoft System CLR Types for SQL Server 2019 Silent Install (How-To Guide)

Microsoft System CLR Types for SQL Server 2019 contains the components implementing the geometry, geography, and hierarchy ID types in SQL Server. This article will serve as an informative guide and give you a clear understanding of how to perform a silent installation of the Microsoft System CLR Types for SQL Server 2019 from the command line using the MSI installer.

How to Install the Microsoft System CLR Types for SQL Server 2019 Silently

Microsoft System CLR Types for SQL Server 2019 Silent Install (MSI)

  1. Navigate to: https://go.microsoft.com/fwlink/?linkid=2108808
  2. Download the SQLSysClrTypes.msi to a folder created at (C:\Downloads)
  3. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  4. Navigate to the C:\Downloads folder
  5. Enter the following command: MsiExec.exe /i SQLSysClrTypes.msi /qn
  6. Press Enter

After a few moments you will find Microsoft System CLR Types for SQL Server 2019 entries in the Installation Directory and Programs and Features in the Control Panel.

Software Title:Microsoft System CLR Types for SQL Server 2019
Vendor:Microsoft Corporation
Version:15.0.2000.5
Architecture:x64
Installer Type:MSI
Silent Install Switch:MsiExec.exe /i SQLSysClrTypes.msi /qn
Silent Uninstall Switch:MsiExec.exe /x {5BC7E9EB-13E8-45DB-8A60-F2481FEB4595} /qn
Repair Command:MsiExec.exe /fa {5BC7E9EB-13E8-45DB-8A60-F2481FEB4595} /qn
Download Link:https://go.microsoft.com/fwlink/?linkid=2108808
PowerShell Script:https://silentinstallhq.com/microsoft-system-clr-types-for-sql-server-2019-install-and-uninstall-powershell/

The information above provides a quick overview of the software title, vendor, silent install, and silent uninstall switches. The download links provided take you directly to the vendors website. Continue reading if you are interested in additional details and configurations.


Additional Configurations

Create a Microsoft System CLR Types for SQL Server 2019 Installation Log File

The Microsoft System CLR Types for SQL Server 2019 installer offers the option to generate a log file during installation to assist with troubleshooting should any problems arise. You can use the following commands to create a verbose log file with details about the installation.

Microsoft System CLR Types for SQL Server 2019 Silent Install with Logging (MSI)

MsiExec.exe /i SQLSysClrTypes.msi /qn /L*v "%WINDIR%\Temp\SQLSysClrTypes-Install.log"

How to Uninstall the Microsoft System CLR Types for SQL Server 2019 Silently

Check out the Microsoft System CLR Types for SQL Server 2019 Install and Uninstall (PowerShell) post for a scripted solution.

  1. Open an Elevated Command Prompt by Right-Clicking on Command Prompt and select Run as Administrator
  2. Enter the following command:

Microsoft System CLR Types for SQL Server 2019 Silent Uninstall (MSI)

MsiExec.exe /x {5BC7E9EB-13E8-45DB-8A60-F2481FEB4595} /qn

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.