Knowledge Base - Tikit.info

INFORMATION: Updating Datasets on MSSQL 2017 and Newer.

Published by Mark, 2022-12-08

EzParts Distributed Media is compatible with all versions of MSSQL currently supported by Microsoft. When installing on MS SQL 2017 and newer before running EzUpdater please execute the following command on the EzParts database on your MSSQL Server.

EXEC sp_configure 'clr strict security', 0;
RECONFIGURE WITH OVERRIDE;

For more information see this article from Microsoft:
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/clr-strict-security?view=sql-server-ver16

After Setting CLR some newer version of MSSQL may return the following error:

.
This can be resolved with the following query: You don't need to change it, as assembly ID from your error is 65536, like the one in the script below

declare @assyID bigint;
set @assyID = 65536; -- assembly see ID from EXCEPTION pop-up
declare @clr_name nvarchar(4000);
declare @Content varbinary(max);
declare @hash varbinary(64);
select top 1 @clr_name = clr_name from sys.assemblies where assembly_id=@assyID;
select @Content=content from sys.assembly_files where assembly_id=@assyID;
select @hash = HASHBYTES('SHA2_512',@Content);
exec sys.sp_add_trusted_assembly @hash = @hash, @description = @clr_name;
select * from sys.trusted_assemblies;

Error