Symptoms:

When using EzParts/EzData/EzPartsWeb with SQL2017 and newer for first time, you can get following exception:


Cause:

Starting from SQL2017 CLR assemblies should be added to trusted list.


Solution:

1) Run SQL Management Studio, r-click on EzParts DB, 'New query...';

2) Paste attached query (untrusted_assy.sql), modify it to contain correct assembly id (see screen shot w/ highlighted info above);

3) Execute query by clicking 'Run' button, or hitting 'F5' on keyboard.