MSSQL Msg 10327 해결방법

Msg 10327, Level 14, State 1, Line 1

CREATE ASSEMBLY for assembly 'ClrSql' failed because assembly 'ClrSql' 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.

해당 에러 발생 시 해결방법

ALTER DATABASE [데이터베이스명] SET TRUSTWORTHY ON

출처 : https://social.msdn.microsoft.com/Forums/sqlserver/en-US/b27e8e16-2d84-4eec-a87d-df53b2e298bc/create-assembly-failed-not-authorized-for-permissionset-externalaccess?forum=sqlsecurity