I get the following error when trying to load my assembly, eventough the
first condition is met:

"CREATE ASSEMBLY for assembly 'test' failed because assembly 'test' is not
authorized for PERMISSION_SET = EXTERNAL_ACCESS.  The assembly is authorized
when either of the following is true: the database owner (DBO) has EXTERNAL
ACCESS 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 EXTERNAL ACCESS ASSEMBLY permission."

This is how I do it:

grant external access assembly to [builtin\administrators]
alter database mydb set trustworthy on

Then, this is what fails:

use mydb
create assembly sql
from 'c:\test.dll'
with permission_set = external_access

What am I doing wrong?

simple insert of strings
Complex Query
adjust my code
avoid using cursors....
really large stored procedures