I build a CRL for SQL. It is necessary that it be in UNSAFE mode. When publishing gives an error.

Выполняется создание [Database1]... (47,1): SQL72014: .Net SqlClient Data Provider: Сообщение 10327, уровень 14, состояние 1, строка 1 CREATE ASSEMBLY for assembly 'Database1' failed because assembly 'Database1' is not authorized for PERMISSION_SET = UNSAFE. The assembly is authorized when either of the following is true: the database owner (DBO) has UNSAFE ASSEMBLY permission and the database has the TRUSTWORTHY database property on; or the assembly is signed with a certificate or an asymmetric key that has a corresponding login with UNSAFE ASSEMBLY permission. (47,0): SQL72045: Ошибка выполнения скрипта. Выполненный скрипт: CREATE ASSEMBLY [Database1] AUTHORIZATION [dbo] FROM  При выполнении пакета произошла ошибка.

At the same time, the user of the database has UNSAFE rights, Trustworthy = true . What else might not be clear. I tried to sign the assembly with a certificate. But the stone flower did not come out. What else can you try? I rummaged through Google, and found nothing (

    1 answer 1

    https://blogs.msdn.microsoft.com/dataaccesstechnologies/2011/10/28/deploying-sql-clr-assembly-using-asymmetric-key/ -

    Did as described here - after that it all worked. I think there is no need to describe this decision.