Skip to content

upgrade-sqlclr-assemblies-after-net-framework-update.md

Latest commit

 

History

History
57 lines (38 loc) · 4.01 KB

upgrade-sqlclr-assemblies-after-net-framework-update.md

File metadata and controls

57 lines (38 loc) · 4.01 KB
title Upgrade SQLCLR assemblies after .NET Framework update
description Learn how to update the SQLCLR assemblies used by SQL Server Data Quality Services (DQS) after you've updated the .NET framework.
author chugugrace
ms.author chugu
ms.date 03/01/2017
ms.service sql
ms.subservice data-quality-services
ms.topic how-to
ms.custom
build-2025

Upgrade SQLCLR assemblies after .NET framework update

[!INCLUDE SQL Server - Windows only]

[!INCLUDE support-notice]

[!INCLUDEssDQSnoversion] (DQS) is a collection of SQL Common Language Runtime (SQLCLR) routines that reference Microsoft .NET Framework 4 assemblies. When you install any .NET Framework updates on your computer that affect any such referenced .NET Framework assembly, it leads to a change in the Module Version ID (MVID) of the assembly in the Global Assembly Cache (GAC). This causes a mismatch between the MVIDs of the referenced assembly in GAC and the assembly in [!INCLUDEssnoversion].

If the .NET Framework update requires you to restart the [!INCLUDEssDQSServer] computer, the affected SQLCLR assemblies are upgraded automatically to fix the MVID mismatch issue on restarting the [!INCLUDEssDQSServer] computer. However, for .NET Framework updates that do not require you to restart your [!INCLUDEssDQSServer] computer, an error occurs due to the mismatch in the MVIDs of the assemblies when you try to connect to a [!INCLUDEssDQSServer] using a [!INCLUDEssDQSClient]:

A new version of .NET was installed on this machine. In order to continue to work with DQS please run dqsinstaller.exe -upgradedlls.

To fix this issue, the affected SQLCLR assemblies in [!INCLUDEssnoversion] must be upgraded. You can do so by running the DQSInstaller.exe file with the upgradedlls command line parameter to skip recreating the DQS databases, and just upgrade the affected assemblies. This ensures that your knowledge bases, data quality projects, and any other data in DQS are preserved.

Prerequisites

  • You must be logged on as a member of the Administrators group on the [!INCLUDEssDQSServer] computer.

  • Your Windows user account must be a member of the sysadmin fixed server role in the SQL Server instance where [!INCLUDEssDQSServer] is installed.

To upgrade SQLCLR Assemblies

  1. Start Command Prompt.

  2. At the command prompt, change your directory to the location where DQSInstaller.exe is available. If you installed the default instance of SQL Server, the DQSInstaller.exe file will be available at C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn:

    cd C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\Binn

  3. At the command prompt, type the following command, and press ENTER:

    dqsinstaller.exe -upgradedlls

  4. Rest of the steps are same as steps 2-6 in the Run DQSInstaller.exe from Start Screen, Start Menu or Windows Explorer section in Run DQSInstaller.exe to Complete Data Quality Server Installation.

See Also

Install Data Quality Services
Upgrade DQS Databases Schema After Installing SQL Server Update