Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"Assembly [name] cannot be migrated to SQL Server 2017" error in compatibility check for Configuration Manager database


View products that this article applies to.

In Microsoft SQL Server 2017, you use the built-in database compatibility checker to determine the upgrade compatibility of a Microsoft System Center Configuration Manager database. You also have CLR Strict Security enabled. When you run the check, you receive informational messages regarding the following indicated assemblies: 

↑ Back to the top


Status

The informational messages are by design. Although the assemblies are marked as "UNSAFE," they are handled correctly. You can safely ignore these messages and continue to run the database upgrade.

↑ Back to the top


More information

By default, all Configuration Manager databases should have the "Trustworthy" option set to True in the database properties. This is a requirement both for Configuration Manager and for the CLR Strict Security feature to function correctly.

To verify this setting, open the Database Properties window, select the Options page in the navigation pane, and then locate the Trustworthy row in the Other options list.

4465462-2

↑ Back to the top


Article Info
Article ID : 4465462
Revision : 11
Created on : 10/29/2018
Published on : 10/29/2018
Exists online : False
Views : 191