SQLTeam.com | Weblogs | Forums

How to make existing assemblies on SQL server older than 2017 work with 2017

I have many assemblies on SQL server 2008, that i don't have their dll, so when i'm trying to create those assemblies on SQL 2017 an error occors, "Msg 10343, Level 14, State 1, Line 106
CREATE or ALTER ASSEMBLY for assembly 'SqlRegularExpression' with the SAFE or EXTERNAL_ACCESS option failed because the 'clr strict security' option of sp_configure is set to 1. Microsoft recommends that you sign the assembly with a certificate or asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. Alternatively, you can trust the assembly using sp_add_trusted_assembly." reading about possible solutions i have found that we can use the following options:
1- Disable CLR Strict Security feature (not recommended by microsoft)
2- Enable Database Trustworthy feature (not recommended )
3- Sign CLR Assembly with Asymmetric Key (recommended but the source is required and we haven't it)
4- Sign CLR Assembly with Certificate Key (recommended but dll is required and not exists)
*So Any expert can help us to sign assemblies stored in database? *